Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2006-03-15 : 07:28:09
|
| 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
38200 Posts |
Posted - 2006-03-15 : 13:52:18
|
| All users have a schema now, so if you want to delete them, you must delete the schemas first then the user.Tara Kizeraka tduggan |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-03-15 : 15:18:27
|
quote:
Originally posted by tkizer
you must delete the schemas first
Where would the Login Schemas be in SSMS? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-15 : 15:29:29
|
| Navigate to the database, Security, Schemas.Tara Kizeraka tduggan |
|
|
|
|
|
|
Attach DB - Can't delete users