It is in @Value = Column types

yes , almost all conditions are on encrypted columns.

Hello,

we are using DecryptByKey and EncryptByKey for decyiption and encryption.

i am using employee code to pull the data in that table

but due to encryption in employee code and no...

Hello,

answers are below

Does the encryption/decryption take place in the database or in a higher layer? --- Database

How many rows at a time are you decrypting? --- for some reports all...

Hello,

i have populated two tables using joins for all employees in main table which is taking 3 or more minutes.

This Db has just 5 months data which took me 3...

thanks will try and update.

i need it only on a month basis so i'll update calendar table on parameter basis.

Hello,

he is facing issue due to timelines in Maintanence Plan.

Bhuvnesh,

It is not advisible to schedule two jobs even it is irrelevant.

what do you say.

thank you all

gail,

My question is will the backup wait for the current activities and backup those activities log as well.

I have experience that even at huge load my backup job will complete...

Gail,

Will the backup job wait for the activities( currently running ) to finish and backup the log.

Hope it is not, i have tried in production server when the load is...

Hello,

Is there any other way (other than logfile name in restore job) to confirm the restoration.

Hello,

can you post the SP code and the code you use to call sp( input datatype and how it runs on DB)

Bru,

It is working and i have found out how the database is in NoRecovery mode.

Thanks for your help.

Bru,

Can i know how you have identified it.

i'll certainly do the process again.