SQL Server Profiler - Doesn't show me errors :(

Hi,

I took me a long time to find out that Profiler doesn't tell me if there where any sql errors, it only logs the sql that somebody tries to execute.

How can I trace a database and see if somebody has any errors?

Thank you! :)
EndelmAsked:
Who is Participating?
 
MohammedUConnect With a Mentor Commented:
You don't see all the errors in SQL profiler but some based on your sql profiler configuration/filtering...

Check the following "Errors and Warnings Event Category" available in SQL profiler.

http://msdn.microsoft.com/en-us/library/ms177448.aspx
0
 
EndelmAuthor Commented:
thank you! :)
0
 
EndelmAuthor Commented:
!"$!"#%!"#$"Q!"#%$ of course!!! :)
0
 
thabashCommented:
yes you can detect sql errors

Try the profiler event: "User Error Message".
 
and here some hint based on sql 2000
http://www.informit.com/articles/article.aspx?p=23566
0
All Courses

From novice to tech pro — start learning today.