Autostart

Jun 19, 2008

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

View 3 Replies

SQL Mail Autostart

Dec 17, 1998

Is there any way to have Sql Mail autostart whenever the server is rebooted or SQL Server is stopped and started

Jim

View 1 Replies View Related

Error When Setting MSDTC To Autostart

Mar 9, 2004

Hi!

I'm getting an error message when I try to set autostart MSDTC in Enterprise manager. This problem just suddenly appered.

Error message:
Error 22002: RegCreateKeyEx() returned error5, 'Access is denied'

I hope somebody can tell me what this is :)

View 1 Replies View Related

Identifying Procedures Marked For Autostart

May 18, 2006

Hi all,

Is there a method of identifying all the procedures in a database that are marked for autostart?

i.e. select name from sysobjects where blah = 'autostart'

Thanks,
rocr

View 6 Replies View Related

SQL Server Service (express) Will Not Autostart On Reboot

Aug 22, 2007

This computer gets set to autostart the SQL Server Service, which is set to local, (have also tried local network and user specific), and everything works fine. But when it gets rebooted, the service refuses to start.

We disabled the Mcafee and Windows firewall. No effect.

The SQL Browser and Full Text Index Services start automatically just fine.

Anyone have any experience with this?

Thanks,
Pat

View 3 Replies View Related