SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Attach DB - Can't delete users
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

SamC
White Water Yakist

USA
3464 Posts

Posted - 03/15/2006 :  07:28:09  Show Profile
This may be nothing, or it may be everything.

I tried restoring a 2000 backup to 2005. It fails.

I attached my SQL 2000 DB to SQL 2005. Seems to work fine.

I couldn't delete the users without error (didn't write down the error. Something about the user being involved with something or other, which they are not!) in the DB, a necessary prerequisite to assigning the corresponding 2005 users to the attached DB.

Minor problem or big problem?

My work around... Back to 2000, delete the users, detach, attach in 2005, assign the local users.

The 2005 DB seems to work fine now. Did I skirt a problem that will need to be addressed?

Sam

tkizer
Almighty SQL Goddess

USA
37157 Posts

Posted - 03/15/2006 :  13:52:18  Show Profile  Visit tkizer's Homepage
All users have a schema now, so if you want to delete them, you must delete the schemas first then the user.

Tara Kizer
aka tduggan
Go to Top of Page

SamC
White Water Yakist

USA
3464 Posts

Posted - 03/15/2006 :  15:18:27  Show Profile
quote:
Originally posted by tkizer

you must delete the schemas first
Where would the Login Schemas be in SSMS?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37157 Posts

Posted - 03/15/2006 :  15:29:29  Show Profile  Visit tkizer's Homepage
Navigate to the database, Security, Schemas.

Tara Kizer
aka tduggan
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000