Tuesday, April 27, 2010

Find Orpahend Login Name With Encrypted Password

Here is the script for finding orpahend users with their SID, this script is very useful while server migration from one location to another location.
 
Use Master
GO
SET NOCOUNT ON
SELECT 'EXEC sp_addlogin @loginame = ''' + loginname + ''''
,', @defdb = ''' + dbname + ''''
,', @deflanguage = ''' + language + ''''
,', @encryptopt = ''skip_encryption'''
,', @passwd ='
, cast(password AS varbinary(256))
,', @sid ='
, sid
FROM syslogins
where loginname Not like 'NA%'
and
loginname not like 'Builtin%' and loginname Not like 'sa'
orphaned login details in sql server. sql server login migration script. login migration script. login move move details. users migration script. user move script in sql server 2012. in sql server 2008 r2. in sql server 2008. login move. server login migration. server login move from sql 2005 to sql 2012. sql login with encrypted password. easy script for login movement. login script. SID ID with login, user mapping in sql server, login mapping in sql server, mapping in sql server 2012, mapping in sql server 2008.

1 comments:

Very Good Script...it is very helpfull

Post a Comment