Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachinp
Starting Member
2 Posts |
 Posted - 2011-08-17 : 03:46:58
|
| Hello . I ran a T-SQL using query analyser and created a file . Its getting as 10 MB . When I created a Job , after adding the T-SQL in a stored procedure the file size is getting doubled. Can any one know the reason / or any suggestion to reduce the size. Sachin |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-17 : 04:42:07
|
| may be you're returning duplicate data from stored procedure. Did you add any additional logic in the procedure?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sachinp
Starting Member
2 Posts |
Posted - 2011-08-23 : 07:25:57
|
| No the difference, is thru Job the File is getting saved as UNICODE and when running thru query analyser its as ANSI. So I want to know how the results can be stored as ANSI after runing the JOB |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-23 : 07:44:30
|
| cast all fields explicitly to nonunicode typebetween i dont what job is doing so I'm assuming its a stored procedure.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Running a job makes file size double than what ran