Sunday, May 28, 2006
Occasional SQL User?
SQL Server runs as a service. Brilliant on a server, not so brilliant if you just wasn't to do the occasional bit of development on a laptop!
This is where placing a couple of batch files (remember them?) on your desktop can help.
Create two files, say StartSQL.bat and StopSQL.bat and place the following lines in them respectively.
net start mssqlserver
net stop mssqlserver
Then go to Services (located in Control Panel > Administrative Tools) and set SQL Server (MSSQLSERVER) to Manual startup.
Now, SQL wont start on reboot and you turn it on only when you need to.
Posted by r5d4 at 22:23