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 |
|
jhnegrao
Yak Posting Veteran
81 Posts |
 Posted - 2007-09-14 : 13:16:22
|
| Hello, All!I was monitoring a specific Database using Profiler. I put just Error and Warnings classes, so I need to know what's going on with that Database and if its critical.I've gotten a lot of these errorError: 8180, Severity: 16, State: 1Error: 208, Severity: 16, State: 1I think, that error isn't critical, because its severity is 16. But, I would like to track whats going on.Which classes or event should I monitor in Profiler to get this information?Have a nice weekendJuliano |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-09-14 : 13:19:39
|
| Are you specifically looking only for logins or anything else. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-14 : 13:22:57
|
| 8180 is "Statement(s) could not be prepared."208 is "Invalid object name '%.*ls'."Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2007-09-14 : 14:23:44
|
| I'm sorry! But, what do these message exactly means. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-14 : 14:38:14
|
| Not sure about the first, but the second one means you've got some code that is referring to an object that doesn't exist.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-14 : 22:43:23
|
| Error 8180 is related to error 208, sql can't prepare query because it contains invalid object. For sql2k5, fix 3175 addresses similar issue. |
|
|
|
|
|
|
|
|
Problem gotten from Profiler