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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2006-01-04 : 13:56:27
|
| The BOL has identified 208 as:Invalid object name '%.*ls'.And went into how to find out who owns that object. My challenge is on how to find out what objects are in question first.My profiler trace results show host name, application, login name etc., but I could not find anywhere that ties the error to an object. Does anybody know how to further define the trace that will bring in the objects. The data column of object Name for my trace returned all Nulls.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-04 : 14:42:19
|
| The row immediately following the 208 error in the trace is the query that was attepted. So you'll look at the TextData column to see the query in question.I'm pretty sure that it is the row immediately following the error. It could be the row immediately before the error though. Tara Kizeraka tduggan |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2006-01-04 : 16:12:39
|
| Some of these errors are associated with TLog backup jobs scheduled from maint plan, and the textdata on next row is null, and the row after that is like: INSERT INTO #xp_results and the row before it is SET TEXTSIZE 32767Does that tell me anything useful? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-04 : 16:17:47
|
| I can't derive anything from that.Tara Kizeraka tduggan |
|
|
|
|
|
|
Error 208 help