Rebooting SQL server 6.5?

[Stella]

How to automatically restart the SQL Server 6.5 and how to run a stored procedure after the restarted the SQLserver 6.5?

Thanks.

Stella

[Craig]

Net start servicename.
Net stop servicename.

Run from Scheduled tasks.

For stored procedure execution at start, read BOL scan for startup procs Option for 7.0. Its in the sp_configure stuff for 6.5.

Did you look?


------------
Stella at 6/15/00 10:14:59 AM

How to automatically restart the SQL Server 6.5 and how to run a stored procedure after the restarted the SQLserver 6.5?

Thanks.

Stella