scripts

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » scripts

scripts

Rate Topic

Display Mode

Topic Options

Author

Message

charipg

Posted Friday, March 15, 2013 6:30 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

Hi,

i need a script for script out all jobs in sqlserver2000.

Thanks

Post #1431501

charipg

Posted Friday, March 15, 2013 8:27 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

This Script will create SQL syntax for re-creating existing SQL Server jobs.
The OUTPUT of this script will be a TSQL statement, which can used to recreate the jobs.
I want tose this script to create jobs from one SQL instance to another instance.

Post #1431564

charipg

Posted Friday, March 15, 2013 8:31 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

I need this kind of sqlserver2000 scripts for below .
1.Jobs
2.Logins
3.Users
4.Linked servers

Can some one provide these scripts.

Post #1431565

Lowell

Posted Friday, March 15, 2013 9:08 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 11,648, Visits: 27,768

take a look at the script contributions on the site:
the second link from this results explicitly says jobs for SQL 2000/05/08,
http://www.sqlservercentral.com/search/?q=script+jobs&t=s

I think another search for the other items you mentioned will certainly yield something you could use.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1431582

« Prev Topic | Next Topic »

Permissions