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 |
|
rjrferreira
Starting Member
13 Posts |
 Posted - 2007-05-08 : 10:00:41
|
| I all,I have been made a backup file from a database. That database are in the principal server. This DB as a user as named DBBOOKS.Now, i restore the database in my computer, to keep it local. When i restore the DB the user names DBBOOKS stays at DB, but he don't exists in the new instance, so i can't remove/alter him, because he don't have any Login attributed.So, what i want is, there is anyway to backup a DB without the users? Only tables and info tables?Greetings,Rodrigo |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-05-08 : 10:06:06
|
| >> So, what i want is, there is anyway to backup a DB without the users? Only tables and info tables?Not using a backup.To get rid of the user use sp_dropuser.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rjrferreira
Starting Member
13 Posts |
Posted - 2007-05-08 : 10:14:36
|
| "...The user owns object..."I can´t remove him because he don't have any LOGIN attributed.In Microsofr SQL Server Management Studio Express, when i see the properties windows of that user, i see:UserName: DBBOOKSLoginName: <EMPTY>When i try to alter this user the MSqlSMSE says to me "Login must be specified", and i can't choose a Login, because the field LoginName is disabled! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-08 : 10:41:28
|
| Change object owner to other db user then drop it. |
|
|
|
|
|
|
|
|
Backup