views:

103

answers:

3

I need to write a script that disables SQL Server Express 2008 from running. This script will be ran on about 500 machines. In my script, I'm setting the start up type for all SQL Windows Services to disabled, and then restart the machine.

In my mind, I have now 100% disabled SQL Server Express from running. I don't care about the orphaned files, someday we might want to turn it back on, so for now, the files can remain.

My Question ...

Is there anything lurking behind that can run, that I'm not considering? Have I totally stopped SQL Server Express from executing, if the services remain disabled?

A: 

Why don't you just uninstall it?

RichardOD
If you read the question, he states the reason.
Jason R. Coombs
I read the question- uninstalling it is a viable option.
RichardOD
+1  A: 

if no service is running, then sql server is not running since sql server is made up from services.

Why are you asking? Do you want to uninstall and it say that something cannot be deletet because the file is locked?

codymanix
A: 

Try using

net stop "SQL Server (MSSQLSERVER)"

in the commandline if you do not want to unistall the service.

StarWind Software
Welcome to StackOverflow - you're picking up downvotes on this and other answers you've made because the signature is being interpreted as link spam, and by convention is generally unwelcome. Conventions like these keep the signal to noise ratio very high.
Paul Dixon
to Paul : Sorry, can you show the convention where it is noted?
StarWind Software
Paul: It's noted here http://meta.stackoverflow.com/questions/5029/are-taglines-signatures-disallowed-on-stackoverflow
Bill the Lizard
Bill: okay, but this should be in the place where anyone can see. I can't agree that in Internet everything with SO is a noise and thus - spam. This is an opinion of a single site administration but not the "whole Internet". For example, Technet, MySQL, SQLServerCentral etc. do not make noise beacuse of this. If those are the rules: user has to read them right from the beginning and they must not be somewhere in the "apropos" in some "Forest Codex".
StarWind Software
You are correct - this is the convention here on Stack Overflow, and one that most accept. As Jeff notes in the link above, if you don't like this policy, then maybe participating here isn't for you.
Paul Dixon
@Paul Svirin: This has nothing to do with a single site administrators opinion. If you look at the number of down votes you're receiving the community strongly dislikes the behavior.
RSolberg
@ RSoldberg: well, I had only post corrections with the guys with 10-15+ k. points. Dut not 300, 400, 500... isn't it an administration?
StarWind Software