October 31, 2007 at 2:51 pm
Hello,
When I see blocking in Current Activity in Enterprise Manager, sometimes the table owner listed is different from the table owner listed in the database itself.
For example, an object such as mydb.user1.table shows up in Current Activity as mydb.user2.table during a blocking problem.
Does anyone know why this happens, and what it means?
Thanks for any help!
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
October 31, 2007 at 2:55 pm
isn't there a possiility that both the users have created same table with their prefix name? Thats all I can think of.
November 2, 2007 at 12:03 am
Yes there is no way a table within sql server can have owner changed by itself there is a possibility that same table is reffered by 2 users.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
November 2, 2007 at 7:01 am
In any language things can't happen by themselves. I am assuming another user has created table with the same name but with his schema.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply