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 |
|
arivusql
Starting Member
2 Posts |
 Posted - 2013-11-27 : 04:18:56
|
| Hi, Please help me to how to write a error logs in notepad in sql server 2008ThanksArivu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-27 : 04:42:45
|
| are you asking error logging in t-sql or inside SSIS?If SSIS< you've a text file provider for logging which you can use for getting log in text file.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
arivusql
Starting Member
2 Posts |
Posted - 2013-11-27 : 05:27:53
|
| Actually I am having stored procedure which is sheduled to run inside the job.Inside sp I catch the error and write my own error statement in sql server log using 'xp_logevent'.Now I need to write this error in any text files.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Error log in notepad