How it is showing name of owner different than actual in sql server2000
-
Hello friends!!!!!!!!!!!!! I expand "Management" then I expand "Current Activity" then I expand "Locks / Object" in the tree on the left side (not the opened window) I see a list of databases and the objects in each database currently with a lock placed on it. Most of the listings in this tree are something like: Northwind.dbo.Categories but what I'm seeing for one particular database is something like this: Northwind.jdoe.Categories Normally I make all objects owned by dbo, however I have some systems that require another user to be the object owner. such example. However the owner of all the objects is not this "jdoe", but let's say "jsmith". In which case I would expect the tree listing the objects being locked to look like this: Northwind.jsmith.Categories NOT Northwind.jdoe.Categories especially, as I stated previously, since jdoe is just a valid user in the db. So, I'm still confused..:confused::confused: How could I remove this jdeo???????????????????? I will remove him by sp_changedbowner. but why and how that 'jdoe' comes in picture!!!!!!!!!! Is there any perticular command or login type work because of that 'jdoe's' name came into picture?????????????????:confused::confused: Help Me Out!!!!!!!!!!!!!!!! Regards shashank