what a want to know is if there s a way to log sql server errors on a log file, table, these errors are not sql server logs which already exists, i want to log dead locks, sql server timeout errors vs on sql server or somewhere.
is it possible ?
may i use sql server profiler for that purpose?
thx in advance..
You can set up SQL Server Alerts that can log to the Application Event Log, or you could write some custom code to log intersing information to a SQL Server database table.
No comments:
Post a Comment