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 |
|
hayko98
Starting Member
29 Posts |
 Posted - 2013-08-27 : 19:25:02
|
| Hi I am running sql script inside job.But sql is not saving the results in the file which i specified('Unable to open Step output file').I tried same thing on different server, it works fine.Both are are 2008 R2.Is there any server level setting that i have to look at.On both servers i logged in as sa.Any ideas why is it working on server1 ,but not on server2?Tnx advance |
|
|
hayko98
Starting Member
29 Posts |
Posted - 2013-08-27 : 20:28:54
|
| Ok got it.It works if i point to this C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\xxxxx.txt path which is default location. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-28 : 02:33:49
|
| it may be that you didnt have access to other location you set as path.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Unable to open Step output file