Personally, I think it would be easier to incorporate the SP into the job or SSIS package than poll the job status. Any chance you can pull all the...

I don't know the answer to your question, but I wonder if you could figure it out by putting a WAITFOR DELAY in your triggers and refreshing each server to...

Check the maintenance plan history: Right click on the maintenance plan, select View History, then expand the failure and look at each entry

Check the job history (similar to above...

I'm using a script like this to track table usage:

SELECT sysobjects.name AS TableName

, CASE when indexes.name is null and type_desc = 'HEAP' THEN 'HEAP'

ELSE indexes.name END AS IndexName

, Type_Desc

, user_seeks...

You need to add a join back to Transport based on the primary key to make sure that it only updates the records that match the INSERTED and DELETED tables....

You might also check to see if it is really a char(13) that you have between those two characters and not a space or tab or char(10). ASCII() will...

CHARINDEX can take an optional starting position and you can use that to tell it where to look for the next "token" - CHARINDEX(CHAR(13), mytextfield, PositionOfThePreviousCR).

Note - you might have...

Can you clarify your issue? If both the source and destination allow nulls, and the @variable is null, the code you have should work, right?

Here's a really...

Are records added to the table in EventDateTime order? I mean, every time a new record is added to the table, is the EventDateTime larger than the previously entered...

If your table allows nulls for those columns, the code you have written will work. If not, you can wrap the variables in an ISNULL to provide a default...

I found it - it's an extended stored proc in the master database: master.dbo.xp_sqlmaint. It's specific for maintenance plans, but you might be able to use it to just...

The RETAINDAYS won't actually cause the files to delete, it just specifies when the file can be overwritten (i.e. with a new backup), and only SQL Server honors the setting...

Howdy RBarry - to get rid of the latency, what if you added a call to sp_start_job? It would return immediately and the job would run "in the background".

Chad

(edited)...

I don't see a problem for a hotfix to address.

Blocking happens when one query locks a resource (e.g. a row on a table) and another separate query needs to access...

I also think that the Username/Account that you supply to log in to the remote server has to be a SQL Account, not a Windows Account. If you have...