Yes, I had been wanted this.

Thanks, it's worked for me

(Nolock) is use for retrieve the data fast at the time  inserting records into hash table also avoid deadlocks 

But my above   question is different,Kindly suggest if any...

Thank you so much, this code is working properly .

Thanks to all

Thanks for sharing the information

In our business we transfer data from one server to another i.e secondary with in one hour using log shipping, so ROT is one hour, so with in one...

Thank you sir,

I have replicate data from one server to another, and my log shipping time is 1 hour, so whatever i have transferred data from...

check below query and suggest how make query for take count of accessed this stored procedure and triggers on SQL server in last 30 days

-- 2 List...

Top means mostly accessed tables or stored procedure by user and bottom means least accessed tables or stored procedure by user on SQL server , I...

Thank's to all for provide such information