February 4, 2013 at 11:57 am
I am deleting out a win login from a database and I get this message:
"There is a schema that has the samename as the user you are deleting. Do you also want to delete the schema?"
I checked around, though, and this win login does not own any objects such as views, tables or stored procs. What is the message trying to tell me?
February 4, 2013 at 12:08 pm
Whisper9999 (2/4/2013)
I am deleting out a win login from a database and I get this message:"There is a schema that has the samename as the user you are deleting. Do you also want to delete the schema?"
I checked around, though, and this win login does not own any objects such as views, tables or stored procs. What is the message trying to tell me?
That there is a schema with the same name as the user you are deleting.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 4, 2013 at 1:08 pm
Although the user does not have own any table, view, ... , the user have a schedma. You have to delete the schema first before dropping the user account.
Otherwise, the schema will lost its owner as an orphan. Does it make sense?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply