I have a test server with both on, the 2005 sql server is the default instance and the 2000 sql server is a named instance. I am assuming that the...

Karl,

Thats why i mentioned smtp mail, I run the checks from a non production server and use this sp to send the mails. Either soulution, the heartbeat check or a...

didn't twig the 3rd party purge batched, unfortunatley without a test bed its pretty difficult to estimate the time difference.

Really dificult to estimate without a test base, what is certain is that with no users connected the only locks created will be from the delete statement.

Could you not...

Might it be easier to insert the records not to be deleted into a copy table (could use nolock if no one is updating table) with same structure and when the...

If select @@servername returns the wrong servername then issue:

EXEC sp_dropserver 'WrongServerName'

EXEC sp_addserver 'CorrectServerName', 'local'

You may also need to change the originating server in sysjobs otherwise the sql agent will think...

You can use the extended sp master.dbo.xp_servicecontrol

create table #SQLServiceStatus

(status nchar(30))

insert into #SQLServiceStatus

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

--for 'SQLServerAgent'

insert into #SQLServiceStatus

EXEC master.dbo.xp_servicecontrol 'QueryState', 'MSSQLServer'

--for 'MSSQLServer'

It returns 'running' if running, you can use...

Bit of a drag looking through the log, you could run the blocker utility provided by http://support.microsoft.com/default.aspx?scid=kb;en-us;271509

and then run SQL Sherlock to analyse the results

http://www.sqlteam.com/item.asp?ItemID=21737

This won't help you...

if it is only commas that is in the field cound you not use replace and join on the values without the commas?

Why not use SMTP mail via: http://www.sqldev.net/xp/xpsmtp.htm

You can build the filename using a the filename+getdate()

if its been encrypted by sql servers nativeley then you can use the tool listed on this site to decrypt it:

http://www.derkeiler.com/Mailing-Lists/Securiteam/2001-12/0101.html

use sp_attach_single_file, look it up in bol

Martin,

Cheers, I had a quick look and this looks good.  Thanks

USE MyDB     

EXEC sp_updatestats

If you are returning the results of the xp_cmdshell to a table on a machine outside the dmz, then it would be the MDTC that will be blocked.