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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-07-10 : 12:50:23
|
| I started running profiler a few days ago checking for errors and warnings. I saw a large number of 208 errors "Invalid Object Name". While looking into the problem I noticed if I drop or create a stored procedure, a 208 error is detected by profiler. Why does this occur since my id has sysadmin permission. Query Analyzer shows no such errors.Dave |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-10 : 12:53:14
|
| If you trace all the sql statements does it show anything?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-07-10 : 14:19:26
|
| Nope. I did notice the "drop procedure" does not cause the error. It's only the "create procedure" and only when a stored proc contains a "create table" and an "insert table" statement.Thanks, Dave |
|
|
|
|
|
|
Strange 208 Error with Profiler & Create Procedure