Perry & sgmunson, 

This was done by another groups which apparently missed it out. Thankfully our DR drill was postponed by a week, so we had enough time to...

Henrico,

Thank you very much for the scripts. I appreciate that very much.

SQLCurious

Thanks a lot, Orlando!

- SQLCurious

On a happy path, it should return the details of the row it finds a match for, just one row. A meaningful message, code for any exceptions/errors encountered.

-SQLCurious

Thanks for your response, @gilamonster. I am using SQL 2014. Would you have any recommended sample that is standard and recommended?

I think I accidentally posted this in 2005...

Thanks, @Lynn Pettis. That's a wonderful article.

Thanks, @Phil Parkin

Thanks for your suggestion, Luis Cazares. It worked for me perfectly. I appreciate your valuable time on this.

SQLCurious

Thanks for the responses. I appreciate your time and effort very much!

SQLCurious

Thanks, Perry Whittle. I will read these and give it a try. I will keep you posted on how it went.

- SQLCurious

I store my dates as integers (in YYYYMMDD format) and have an index on them. I have another DimDate table that has YYYYMMDD as clustered PK, and the remaining columns...

Thanks, Eric. Unfortunately, that's not enough for me since it will only tell me that the object has been modified...that too the most recent one. I need to know what...

Thanks for your valuable inputs, @pietlinden/@Luis Cazares/@ScottPletcher/@Eirikur Eiriksson

SQLCurious

@Grant: Thanks for the advice.

Here is an updated situation. There is a trace file running already that is capturing all the events triggered by a certain set of users (profile...

Thanks for the link, @pietlinden. I will go through the article.

Just to re-phrase my original request, I am not looking for a single query. This is a one-time...