Post reply

SCM Utility

  • April 27, 2004 at 11:01 pm

    #82744

    Hi All,

    I am looking for a way to turn off sql services so that I may perform defrag tasks with diskeeper. I have found the SCM utility which allows you to start and stop a service...and this works well. However, the prompt box which displays is very annoying. Is there some distant chance a 'no prompt' parameter so this command can run silently?

     

    Thanks in Advance,

     

    Terry

  • April 28, 2004 at 12:04 am

    #504429

    Try this from a command line

    net stop sqlserveragent

    net stop mssqlserver 

     

     


    -- Amit


    "There is no 'patch' for stupidity."


    Download the Updated SQL Server 2005 Books Online.

  • April 28, 2004 at 1:17 am

    #504442

    There is an undocumented (for obvious good reasons ) xp in SQL Server named xp_servicecontrol. You can use it to start and stop services from within SQL Server.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • May 5, 2004 at 6:18 pm

    #505385

    Thanks all, I ended up using net start and stop as scheduled tasks. Seems to be working fine.

     

    Cheers,

    Terry

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply