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 |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2006-06-14 : 13:31:26
|
| Just wondering if anyone knows if SQL Server logs the status of a DTS Package (succeess or failure) and same for Stored procedures? If so, How to view the log.Thanks |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-15 : 02:58:07
|
| In the DTS package properties there is an option to store the logs to a O/S file. Stored procedure success can be tracked with in the SP itself, use @@ERROR at the bottom of the SP.------------------------I think, therefore I am - Rene Descartes |
 |
|
|
|
|
|
Logging