Post reply

Does 2000 have an equivalent to 2005's "Script Login As"?

  • January 15, 2008 at 9:38 am

    #91633

    i need to make a quick backup of select logins on a SQL Server 2000 box. is there a 2000 EM tool similar to 2005's "Script Login As"? if not, is there a simple script to backup a single login to be able to quickly restore?

    thanks.

  • January 15, 2008 at 4:04 pm

    #768386

    The easiest way I can think of is to us the 'generate SQL script' database option in Enterprise Manager. R-click on any database, choose 'All Tasks' then 'generate SQL script'. Go right to the Options tab and select 'Script SQL Server logins'. Click 'OK' and save it to a file which you can edit and pick out the specific logins you want.

    Greg

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply