June 1, 2005 at 8:14 am
Hello friends!!!!!!!!!!!!!
I update my post
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. The database in question is on
e
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 no longer a valid user in
the db.
So, I'm still confused..
How could I remove this jdeo????????????????????
Help Me Out!!!!!!!!!!!!!!!!
Regards
shashank
Regards,
Papillon
June 1, 2005 at 8:43 am
Right click on the ProcessID (spidxxx) in the tree view, then select help. It explains owner in there (it is the lock owner, not the object owner):
| Owner | Owner | The lock owner: xact (transaction), sess (session), or curs (cursor). |
June 2, 2005 at 9:32 am
sp_changedbowner
Vasc
June 2, 2005 at 10:05 pm
Hello friends,
..............Thanks for your reply,
...............but my question is how that comes,
...............i will change the owner,
...............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?????????????????
Please help me out!!!!!!!!!!
Regards
Shashank
Regards,
Papillon
June 2, 2005 at 10:21 pm
I have experienced the same problem...
In SQL server when creating table you must specify owner.
Eg. CREATE TABLE dbo.table_name (..)
If you do this: CREATE TABLE table_name (..) , then ownership of this table will be the user name. Just like "jode.table_name".
This goes for procs, functions..etc.
ND
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply