March 16, 2009 at 4:12 pm
I have NT Login domain\myuser
This user is mapped to a database and schema owner dbo and database role is db_owner.
User couldn't connect so i tried to delete this and it keeps saying account owns schema.
How to remove and readd.
March 16, 2009 at 5:39 pm
TRACEY (3/16/2009)
I have NT Login domain\myuserThis user is mapped to a database and schema owner dbo and database role is db_owner.
User couldn't connect so i tried to delete this and it keeps saying account owns schema.
How to remove and readd.
Change the schema owned by this login to 'dbo' and then delete the login, and later change the schema as required under a login.
March 16, 2009 at 5:41 pm
The schema is set to dbo.
March 16, 2009 at 6:25 pm
TRACEY (3/16/2009)
The schema is set to dbo.
So still you can't delete the login? Did you query sys.database_principals and look at what schemas does this login own?
March 16, 2009 at 8:16 pm
Nothing in there which is correct .........as no objects associated.
I try again and see what i get perhaps a connection was intact.
Cheers.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply