June 11, 2009 at 3:57 pm
Hi All,
Whenever we have database errors such as permission issue (new db objects deployed without properly granting permissions) or duplicate keys, or foreign key violation etc..... We never seen them in the server log. Is there a parameter to turn on or setting trace flag or ???? to log these database errors in the server log. We have seen other server msgs like Database backup, log backup etc...
We're running on Microsoft SQL Server 2000 - 8.00.2039, Enterprise Edition on Windows Server 2003.
Thank you for your help.
June 11, 2009 at 6:54 pm
Hello,
I think you will have to do this on a message by message level, by configuring “With Log” for each error number that you want written to the SQL Server Log.
Take a look at the BOL Topic “sp_altermessage”
You might (briefly) consider turning on C2 Auditing, but that is most likely overkill, has a performance hit and will stop your Server from working if Log space runs out.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
June 15, 2009 at 11:39 am
Hi John,
It works fine just the way we wanted.
Thankyou very much.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply