Sunday, 28 May 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.

No comments: