Automated Administration How-to Topics (Transact-SQL)

Many of the repetitive tasks performed when administering a Microsoft SQL Server system can be automated.

Jobs and tasks can be defined to run at specific times or after specific events. These jobs are most often defined using SQL Server Management Studio, but they can also be defined using Transact-SQL statements. The topics in this section describe how to use stored procedures to implement automatic administration of SQL Server.

In This Section

See Also


Automated Administration How-to Topics (SQL Server Management Studio)

Other Resources

Automating Administrative Tasks (SQL Server Agent)

Help and Information

Getting SQL Server 2005 Assistance