Thanks again Adi. I was bit confused with the datepart function

Thanks. Basically, i was trying to findout the difference in seconds between 2 given dates.

Thanks Gila & Ninja. Actually, this is sample table and the original table has got 47 columns and 26000 rows.

So far, i wrote a SP that accept old value and...

Thanks for your reply. I didn't get you? which password is wrong? i am using DECRYPTBYKEYAUTOCERT here.

Thanks Dev. I didn't think about it.

Found the problem and fixed it.

When imported the database from 2000, the owner was different, that causing the issue.

Thanks Nakul. I will discuss with our team for the possibilities to implement DB mirroring.

Thank you all for your support and time. As suggested, i will ask application guys to re-design the table structure. Thanks again.

Thanks Lutz. At last, i need to create a UDF by passing CUST_ID

The table contains CRD_X column related to BID_X column.

If any CRD_X contains value "CR" then i need to...

Thanks Ashish.

Yeah, i already i put the data in the lab. inserting into new tables (6 months data) is much easier than deleting 1.5 year data in the original...

Thanks Ashish & Sachnam. BTW Ashish, i like your quote 😀

My problem is that, i need to break the replication. complete the tasks and delete the subscriber and create all...

Thank you Todd for your help.

Thanks Suresh.

master..xp_readerrorlog will list out the error logs.

Hi Nagesh,

Can you modify the plan, and go "Manage connections", local connections. You may change the user name /password and save the MP again. This should solve the problem.