SQL Server Performance

autostart

Discussion in 'SQL Server 2005 General Developer Questions' started by arkiboys, Jun 19, 2008.

  1. arkiboys Member

    Is there a sql syntax to set sql server and sql server agent to autostart? I can not find anything regarding this.
    Thanks
  2. Adriaan New Member

    In SQL 2000 and previous, there was the Service Manager tool with a checkbox for "Auto-start service when OS starts" for the server instances registered in the current profile. Something similar should be available in SQL 2005.
    I'm assuming this works on the OS level, so I wouldn't expect there to be a T-SQL command to switch it on or off.

Share This Page