Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » 2008   (RSS)

Quick Bytes: Configuring XP_cmdshell and Agent XPs in SQL Server 2008

Here are ready to use SQL scripts For Enabling XP_cmdshell: USE master EXECUTE sp_configure 'show advanced options' , 1 RECONFIGURE WITH OVERRIDE GO EXECUTE sp_configure 'xp_cmdshell' , '1' -- use 1 to enable it, 0 to disable it RECONFIGURE WITH OVERRIDE
Posted by ssehgal | 3 Comments

Automating SQL Server 2008 installations

Ever wished you had a way to capture the installation configurations you specify while installing SQL Server on a machine and replicate the same on other machines, without having to go through the wizard every time and filling up the values. If yes, then
 
Page view tracker