What do you mean by monitoring from client end? The job /...

I hope this would work, add the following code in your query and change the name of the DateColumn.

where Getdate() > Dateadd(mi,30,DateColumn)

It needs more time to simluate the same data at our end to come up with a script,

please post the table scripts and some sample records as per the...

I wan't replying MySQL Server as a result of your equation.

I was suggesting a new phrase that's it..

How about this MySQL Server 😛

This is at least strange way, there are others who have posted weird ways of asking help ...:-)

You don't know whether they are seeking suggestion, making a challenge or making...

I don't think applying Indexes in your database caused that error.

If you feel so, have you tested it by dropping the indexes and run the SP?

lmu92 (11/27/2009)

I...

Implemented based on Primary key in the tables And / Or based on datetime Columns that are used to track the data that needs to be moved.

It's a general question...

I guessed it, that's why I gave the link to Steve's thread.

For what?

It could have been better had you posted this in reply to Steve's thread.

@http://www.sqlservercentral.com/Forums/Topic825418-263-1.aspx

Linked Servers are there, is it not something you are considering?

I believe this thread started around that, I second Luckysql's thoughts regarding the DTC not a requirement to have...

If your goal is to import data from an Excel source for one off time, then you can use Import / Export wizard available in SQL Server.

Whenever using temp tables, verify data after insertions / updations and make sure it looks what you expected.