May 5, 2008 at 12:29 pm
I have a SQL Server 2005 DB that was developed on our Development Server. The DB was then moved to a production server however we had some problems with that server and the DB was detached from that server and attached to another server. All of the users were dropped from the DB and re-added on the new server however there is 1 user that I cannot drop or modify. That user has the datareader and datawriter schema assigned to it.
May 5, 2008 at 1:00 pm
What error do you get when you try to drop it?
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
May 5, 2008 at 1:31 pm
Drop Failed for User 'bbch\jsmith'. (Microsoft.sqlServer.Express.Smo)
Additional Information:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
The database principal owns a schema in the database, and connot be dropped. (Microsoft SQL Server, Error: 15138)
The above is the error message I'm getting. I've also learned that the Server this DB was originally set up on was SQL Server 2005 Express Edition. When it was moved to a different server it was moved to SQL Server 2005 Standard Edition. All of the other users were dropped and re-added exept for this one.
May 5, 2008 at 2:20 pm
RayMilhon (5/5/2008)
Drop Failed for User 'bbch\jsmith'. (Microsoft.sqlServer.Express.Smo)Additional Information:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
The database principal owns a schema in the database, and connot be dropped. (Microsoft SQL Server, Error: 15138)
Reassign the owners of the Datareader & Datawriter schemas back to db_datareader and db_datawriter first.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 5, 2008 at 4:04 pm
How??? Everytime I try it says I can't
May 5, 2008 at 4:12 pm
Never mind. I found it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply