Re: A script to capture Orphan userids
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 01/19/05
- Next message: Bill Papanestor: "Creating SQL Agent Job to Run Trace Script"
- Previous message: Sean Lamberson via SQLMonster.com: "exporting to dbf"
- In reply to: Do Park via SQLMonster.com: "A script to capture Orphan userids"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 Jan 2005 11:06:49 -0600
As Yih-Yoon Lee has posted, the solution is to use sp_change_users_login
I have found this article helpful. It contains a couple of stored
procedures that allow you to script logins and their SID. You can use these
to create logins on "downstream" (non-production) servers. As long as users
are created somewhere and their SIDs are carried forward you should not end
up with orphaned users.
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
-- Keith "Do Park via SQLMonster.com" <forum@SQLMonster.com> wrote in message news:9ba509aa5f3a4496ba55516802843699@SQLMonster.com... > Hello > > We've had problems about orphan userids in Development SQL server. Application DBAs restore databases from Production SQL server a lot of time. So I'd like to set up an automation using a script to catch orphan ids. > > Is it possible to use a script to capture(or select) orphan ids? > > Thanks in advance, > Do. > > -- > Message posted via http://www.sqlmonster.com
- Next message: Bill Papanestor: "Creating SQL Agent Job to Run Trace Script"
- Previous message: Sean Lamberson via SQLMonster.com: "exporting to dbf"
- In reply to: Do Park via SQLMonster.com: "A script to capture Orphan userids"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
