Hi

Execution plans seem to be the same. But one thing i found that the first join condition that we write with the "on" clause

should be between the last and the...

Pls explain clearly and in detail.

SELECT SERVERPROPERTY ('InstanceName')

or what about a simple database backup. If your developers are going to make a lot of changes or database size is huge this may not work out.

Express edition does not support SQL mail

How did you put the message in red

Hi

I have corrected a portion of your proc. u can continue in the same manner.

set @sSql='select iCustomerid,sCustomercompname from CustomerMaster C inner join Citymaster Ci ...

Hi

What do you mean by "where clause". If its the where clause of a sql statement then you can use a function instead of a procedure.

maybe a trigger could help

Hi

My 2 cents...

When u send the backup from server A to server B you create a entry in a table. when the backup is restored you can update the entry...

Hi

You could put your db into simple recovery model and then delete small "portions" of data.

That is the proper way to retrieve encrypted data. I do not know of any other way for this.

Hi

If you have indexes on the tables you can use the DMV sys.dm_db_index_usage_stats to get the

last seek,scan,lookup or update. you will have to take the most latest date from...

Hi

I have'nt understood your point... but if 8000 char is a limitation you can use xml data type or Varchar(MAX) .

Dont think you can do this. Each time you encrypt the same value you will get different encrypted values.