May 17, 2008 at 5:09 pm
i have been trying the start up procedures, and then tryed to shutdwon the SQL Server from executing this line
exec xp_cmdshell 'net stop MSSQLSERVER'
now putting all this together i have created a startup procedure to shutdown sql server as soon as the service starts.
i know that sql server will never start again, but i thought that i can fix this some how, but i couldnt.
hahaha
do u have some thing to do the job????????
and if any one with sysadmin role want to kill the system, in this way its very easy...
..>>..
MobashA
May 17, 2008 at 9:04 pm
Write a NET.BAT file like this:
ECHO Hi!
And put it in the default directory of your xp_CmdShell command.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 18, 2008 at 12:59 am
my goal is to try create this case and try to get out of it cos if any one did it to the server u have to know what to do.
create proc test
as exec xp_cmdshell 'net stop MSSQLSERVER'
then mark the procedure as a startup one.
when the SQL Server shuts down it will never startup again.
..>>..
MobashA
May 18, 2008 at 6:21 am
could u tell me were the default directory for Xp_CmdShell?
..>>..
MobashA
May 18, 2008 at 7:14 am
exec xp_cmdshell 'cd' --> this will return the current directory
exec xp_cmdshell 'echo %PATH% --> will return the current path information
http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx
Hope this helps...
May 18, 2008 at 11:43 am
i tryed to start the sevice from the command line and uesd -f parameter.
the service started, then dropped the procedure and every thing went good, am still going to try ur solutions.
..>>..
MobashA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply