sql server 2000 to 2005 error moving logins

• timscronin

  SSCertifiable

  Points: 6851

  More actions

  March 13, 2008 at 3:36 pm

  #69992

  I found a script on a MS web site to move logins from sql 2000 to sql 2005 which I need to do. I restored the 2000 db's to the 2005 servers, than ran the script. It created the statement below to add the login. I ran it and got the incorrect synatx error near login

  What's even better, the line below comes from BOL and it gives the same error, am I missing the obvious?

  CREATE LOGIN [STLNTDOM\AArriaza] FROM WINDOWS

  CREATE LOGIN [ADVWORKS\fogisu] FROM WINDOWS

• timscronin

  SSCertifiable

  Points: 6851

  More actions

  March 13, 2008 at 4:31 pm

  #789354

  Please ignore stupid, I was connected to the sql 2000 box when I tried this, in the words of my hero Homer Simpson

  DUUUUUUUUUUUUUUUUUUUUUH!!