The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system. By default, the xp_cmdshell option is disabled on new installations and can be enabled by using the Policy-Based Management or by running the sp_configure system stored procedure as shown [...]
Archive for May, 2009
How To Enable xp_cmdshell On SQL Server 2005
May 5, 2009How To Copy SQL Server 2005 Jobs From One Server To Another
May 1, 2009
This example shows how to copy a scheduled backup job from one instance of SQL server 2005 to another.
In Microsoft SQL Server Management Studio, expand the SQL Server Agent tree.
Expand the jobs tree.
Here you will see a list of all the jobs currently stored on the server.
Right-click on the job that you want to copy [...]
