missieh
4Penny.net
Points: 10700

11/23/2015 3:43:17 PM

Migrating Logins SQL 2008 R2 to SQL 2014

I used an older code to try and migrate the logins from 2008 R2 to 2014  and it wasn't recognizing sysxlogins 

 

IF (@login_name IS NULL)
  DECLARE login_curs CURSOR FOR 
    SELECT sid, name, xstatus, password FROM master..sysxlogins 
    WHERE srvid IS NULL AND name <> 'sa'
ELSE
  DECLARE login_curs CURSOR FOR 
    SELECT sid, name, xstatus, password FROM master..sysxlogins 
    WHERE srvid IS NULL AND name = @login_name

 

 

so I found an updated code...

4Penny.net
Version: GP 2010,GP 2013,GP 2015
Section: Dynamics GP,SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3