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 |
|
san
Starting Member
26 Posts |
 Posted - 2002-06-05 : 19:10:57
|
| I have to make a custom log file in SQL server. I need you guys help.I will have a job that is just a stored procedure scheduled for every 30 minutes. That stored procedure should run a query and write the result in to a log (.txt)file. This TXT file, if possible should be there in some other machine than the actual Database server machine.How would I do that ? For some reason I cannot use iSql. Please help..Thanks guys..San |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-06 : 03:29:31
|
| Try DTS....PeaceRick |
 |
|
|
dsdeming
479 Posts |
Posted - 2002-06-06 : 08:07:49
|
| You can also bulk copy the contents of a table or the results of a query out to a file. It's fairly simple to dynamically execute the bcp utility. |
|
|
|
|
|
|
Custom log in SQL server..