Home Forums SQL Server 2008 SQL Server 2008 - General Upgrade Sql 2000 to SQL 2008 RE: Upgrade Sql 2000 to SQL 2008

  • February 7, 2018 at 5:50 am

    #1978841

    almirfiorio - Wednesday, February 7, 2018 5:41 AM

    NorthernSoul - Wednesday, February 7, 2018 5:19 AM

    Which objects have not been restored? You can bring the logins across using sp_help_revlogin and as for the jobs you can just script those out.

    Thnanks

    Logins and Jobs

    how im can use this script? can send me script and instructions ?

    Google sp_help_revlogin and you will find the script and instructions for how to use it. You will execute it on your source and it will produce a script of the logins to run on your target.

    As for the jobs you can right click on the job and 'script job as'.

    Thanks