Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Script   (RSS)
Monday, June 01, 2009 2:44 PM

Configuring Windows services using Command Prompt

Configuring the properties of a Windows Service using command prompt and scripting it in a batch file is really simple and can save you from performing the same manual configuration again and again. The sc utility comes handy to achieve this. In the example
Posted by ssehgal | 10 Comments
Friday, April 03, 2009 3:09 PM

Passing parameters to SQL script using batch files

SQL Server 2005/2008 provides a command line utility SQLCMD, which can be used to perform basic SQL operations using command prompt. This comes really handy when automating repeatedly used SQL operations. You don’t need to Open the Management Studio every
Posted by ssehgal | 4 Comments
Wednesday, March 11, 2009 7:32 PM

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
 
Page view tracker