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 |
|
kowani1
Starting Member
42 Posts |
 Posted - 2006-11-15 : 03:07:19
|
| Hi All,I am new to this forum, but could anyone tell me a better way to transfer logins between SQL instances.I have tried using sp_help_revlogin on the source servers and then ran the output scripts in the destination server, but am still having issues with orphaned users.Please help me out if I am missing out something.Izak |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-15 : 03:26:16
|
| Have you checked these links:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69666[/url][url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74089&SearchTerms=copy,login[/url][url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53385&SearchTerms=copy,login[/url][url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52429&SearchTerms=copy,login[/url][url]http://support.microsoft.com/kb/246133[/url]Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
vchopade
Starting Member
2 Posts |
Posted - 2006-11-16 : 11:26:36
|
| Hello ,I am facing a problem related to database user.I have restored the database and when i tries to delete the User from restored database it does not allow me to delete and message pop up " The selected user cannot be dropped because user owns the object "Please help to resolve this issue.Thanking youRegardsVivek ChopadeNagpur.( India ) |
|
|
|
kowani1
Starting Member
42 Posts |
Posted - 2006-11-16 : 18:02:19
|
| You need to identify which databases the user you are trying to delete owns objects in. Once you delete the user at the db level, you can then delete the user in the logins.I am sure there is a smarter, scripted way to do this, but I have always done it this way as I don't have too many databases when I restore/refresh test dbs with production data.The only issue I face is with passwords and sids ; often associated with orphaned users. |
|
|
|
|
|
|
Transfering logins betwen SQL 2000 Servers