Hi,

as I can run/stop the services of SQL, OLAP (SQLAgent) by means of commandos T-SQL

Thank,

John

YOu can start and stop SQL Server engine and the SQL Agent services via the command prompt using NET START and NET STOP. Don't know of a way via T-SQL unless you use the exteneded stored procedure xp_cmdshell.

Scott

start:
EXEC master..xp_cmdshell 'net start SQLSERVERAGENT'

stop:
EXEC master..xp_cmdshell 'net stop SQLSERVERAGENT'

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/