SQL Server 2K5 Log file

[dmando84]

Hello,

I wrote a stored procedure in SQL 2K5, and I would like to write to the sql log file when certain steps have succeeded. The only way I know how to do this is by using the raiseerror command, but I am not looking to exit the proc after writing to the log file.

Any help would be appreciated...


Thanks,

Dave

 

[foxdev]

Why try to write to the built-in log file, rather than creating a user table and writing to that? It would make reporting and whatnot much more flexible.

--------------

http://www.foxdev.com

 

[mrdenny]

The procedure xp_logevent will allow you to write to the ERRORLOG.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog