single table backup.

pp source table -->select id,PPID,Name,Create_Date,Modified_Date, isactive from A.PP
pp_old destination table.--> select id,PPID,Name,Create_Date,Modified_Date, isactive from A.PP_old

good .
same way can you please post code  to the get the alert when  Always on server changed primary server to secondary server

after role changes i need to disable the all jobs in secondary server and enable the jobs on the primary server.
can any one suggest script for this.

after data copying to uat server i want retrive the report what are IDs are updated today.

no my database still in restoring mode how to chnage to standby / readonly

(i have taken full copy only backup and applied on secondary database with no recovery)

thanks

can you please share the code

how to delete by batch wise

hi,

thanks for sharing.

already that database in simple recovery model.

but deletes it is more time.

how to resolve this issues very fastly

even inserts dont take this much time.

Hi,

i need code for need to identify the tables having regular updates on the database and it will automatically update the statistics of that tables.

hi,

in my shared location db backup is .lbak

thanks

can any one tell differences between clustering and always on

Hi,

what is backup command to take the transaction log backup from 3:00 to 3:38 PM

Probably, you have found an answer to your question by now. This answer is for others who might stumble upon this question. I don't think you can use object variable...

no jonson..

Object variable and i would like to send this results using a Send Mail Task using the following expression on the MessageSource.

"Please find attached data summary" + SUBSTRING( @[User::myVariable]...