Automated SQL Server Startup

Is there any way start a SQL Server database through a script and still
be able to administrate the server through EM? I have created a scripts
for shutting it down and e-mailing me, but I would like to automate
startup through a scheduled task as well.
Thanks...
NathanFigured it out net start...
doh.
nathan
none@.nnn.com wrote:

> Is there any way start a SQL Server database through a script and still
> be able to administrate the server through EM? I have created a scripts
> for shutting it down and e-mailing me, but I would like to automate
> startup through a scheduled task as well.
> Thanks...
> Nathan
>|||Hi,
I've created 2 batch file, startsql.bat and stopsql.bat. Each have 'net str
at mssqlserver' and net stop mssqlserver' for starting and stoppping the ser
ver. I schedule it in the Schedule (under control panel) by selecting to ru
n the program as startsql.b
at or stopsql.bat and the user id is my window administartor login id and p
assword. I waited and watched and nothing happen. What am I not doing corr
ectly? Is it the batch file or is it the schedule not done correctly? I am
running Window 2000 and SQ
L 2000
Thanks,
Alpha