DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
missieh 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