February 3, 2013 at 3:24 am
Hi........
Any one can provide the solution for the below error in detail.
Error Message in SQL SERVER 2005:
"Deleting Server logins does not delete the database users assciated with logins. To complete the process, delete the users in each database.It may be necessary to first transfer the ownership schemas to new users."
February 3, 2013 at 7:38 am
That's not an error.
That's an informational message informing you that deleting logins does not delete the associated database users and to complete the delete you have to delete the database users yourself, potentially first transferring ownership of objects of schemas to other users.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 3, 2013 at 11:23 am
Hi GilaMonster,
Thank you so much for your quick response,
If possible can you provide me the right solution for this in a detail way.
February 3, 2013 at 12:09 pm
GilaMonster (2/3/2013)
That's an informational message informing you that deleting logins does not delete the associated database users and to complete the delete you have to delete the database users yourself, potentially first transferring ownership of objects of schemas to other users.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply