Thanks.

So after the failover has occurred, I should map the logins to the database?

That was so simple. Thanks

sample data in A

[highlight="#ffff11"]GUID FBNUM ...

Thanks for you reply

The fields in A table are truncated and populated with new data every week

all other fields might match but the date field doesn't

Not only the first...

Perfect Thanks

Thank you for all your effort.

I just want to remove that particular record. It's not always on the first row, it can be anywhere in the table.

I have so many NOT IN conditions like ::

Select * from backups

where

databasename not in (select databasename from backups where servername ='d900'...

We use 2012. I dont think my organization agrees to that, they only have a requirement to encrypt 2-3 columns of a table. I think TDE is for the data...

Thanks for the reply. I thought of putting up XML Indexes, but the concern is the table is huge it will take a lot of time to create the indexes.....