This will read the registry and give you what you need, I got it from this site after posing the same question:

declare

@reg_srv varchar(256

Try the query like this:

select whatever from table OPTION (MAXDOP 1)

The number in the maxdop hint is the number of procesors the query will use, I would also look at when the...

Without looking at the code my only question is whether the machine this is running on is a multi processor box. If so I would look at using the maxdop...

Yes thats what I thought, but maybe I am just not findong it. Maybe it will be back in the first sp.

This is the sql EM fires when you do a refresh and a base is being restored:

select name, DATABASEPROPERTY(name, N'IsDetached'),    

(case when DATABASEPROPERTY(name, N'IsShutdown') is null then -1

else DATABASEPROPERTY(name,...

This should give you what you need

select DATABASEPROPERTY(name, N'IsInRecovery') end)

Phil,

Thanks for this, this does exactly what I have been looking for. Does this work against 2005? Do you have any plans on writting a new version that will if...

Sounds like the execution plan may have changed, do you have a set of input params that you know where being processed in the past in a reasonable time. If...

have you restarted the service?

You need to open the surface area configuration tool and click the option for remote connections and then click local and remote connections option. Use bol 2005 for more dtails 

I have seen this before, what they are realy saying is that it would be more difficult to recode there work. It would not supprise me if there are orphaned...

Running this in the distribution database will give you a history of the distribution agents. You can modify the view to look at the other agents wich have there history...

sear5ch this site for scptxfr.exe

search this site for USP_KillUsers, this script will give you what you want

take a look at this:

http://www.informit.com/guides/content.asp?g=sqlserver&SeqNum=31&rl=1