From what that Links says I think you are right - Now I need to get the patch

Cheers

Geoff

Not quite sure of exactly what you are wanting. Did you want the component to continually open and close a connection and log response times etc, or failure messages?

If...

Answered my own question.

Here it is

This query creates a script which you then need to run the results of

select 'drop index ' + object_name(id) + '.' + [name] from sysindexes

where...

I always manage to forget xp_cmdshell

This seems to work well though I do like the xp_servicecontrol, its creates a lazier solution.

I have the solution

EXEC master..xp_servicecontrol 'QueryState', 'SQLServerAgent'

This returns a string detailing the current status. You can also stop and start the service with the following commands:

EXEC master..xp_servicecontrol 'STOP', 'SQLServerAgent'

EXEC master..xp_servicecontrol...

Unfortuately I am not currently using SQLDMO, if possible I would like to test if is running within ADO. I have found xp_sqlagent_is_starting which returns 0 if it not currently...