SQL SERVER Start and Stop services Using SSIS
undefined
undefined
Case
Constantly running all Microsoft SQL Services on your development desktop/laptop could be a little too much. Especially when you're not developing, but starting and stopping via the control panel is tiresome...
Solution
You can stop/start a service via the command (or even better, put it in a batchfile):
Constantly running all Microsoft SQL Services on your development desktop/laptop could be a little too much. Especially when you're not developing, but starting and stopping via the control panel is tiresome...
Solution
You can stop/start a service via the command (or even better, put it in a batchfile):
Syntax NET START [service] NET STOP [service] NET PAUSE [service] NET CONTINUE [service] Key service : The service name as shown in Control Panel, Services
Stop batchfile SQL 2008: @ECHO OFF NET STOP "SQL Server Agent (MSSQLSERVER)" NET STOP "SQL Server Integration Services" NET STOP "SQL Server Analysis Services (MSSQLSERVER)" NET STOP "SQL Server Reporting Services (MSSQLSERVER)" NET STOP "SQL Server (MSSQLSERVER)"
Save Above Text As STOP.cmd
Start batchfile SQL 2008:
@ECHO OFF NET START "SQL Server (MSSQLSERVER)"
NET START "SQL Server Agent (MSSQLSERVER)" NET START "SQL Server Integration Services" NET START "SQL Server Analysis Services (MSSQLSERVER)" NET START "SQL Server Reporting Services (MSSQLSERVER)"
Save Above Text As START.cmd
Subscribe to:
Post Comments (Atom)
- SSIS Logging Table Customizing
- Getting column description and Update descriptions in SQL Server
- SQL SERVER Start and Stop services Using SSIS
- SQL Server log shrinking Issue
- Dynamic Pivot on Single Column in a Table Sql Server 2008
- Run same command on all SQL Server databases without cursors
- SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables
- Delete Original Data and maintain history with single SQl statement......(Magic tables)
- SQL Server Recursive CTE
- SQL Server Advanced Queries
- Which index will SQL Server use to count all rows
- SQL Server Performance Tips
- Sql Server Temporary Tables vs Table Variables
- Differences between sqlserver 2000, 2005 and 2008 versions
- SSIS Interview Quesions and Answers
0 comments:
Post a Comment