Thanks! Is there a way to configure notification to catch if ever someone issues and shrink log file or data file command?

Thanks! I tried both option, nothing i could see for the last month. Option 1 query did not show anything for last month. Option 2,Disk usage report has no entry...

Thanks! However, i don't have mirroring configured in test, so i have no other option just pulling the trigger in Prod.

I was deleting with the batch size only. However, it started deleting more rows when i change the where clause older than 1 yr and previously it was older than...

A table with few columns.

Thanks for the information, at this point i have to Audit only one table. Based on the information you provided i would think trigger or extended events would be a...

I would like to Audit tables so looking the best possible solution, Is it C2 Audit mode or trigger or any other best possible solution you can advise?

Thanks

Could you please provide more details?

Thanks

Thanks! However, i don't need help on the execution plan, all i am looking for is adding index benefit vs resources.

Yes it has significant improvement after creating the index. These are replicated tables and tables get populated through replication all the time.I am sure adding one index would not cause...

Any advise?

Hi Sue,

I have a question about database mirroring. We are upgrading the database server which have mirroring configured. The upgrade would happen on different server with different name(basically...

Thanks Sue! Another question, 
We are configuring transaction replication on the Test server which is going to be production(it has already replication configured from Server A to Server B). When...

Thanks Sue! Another question, I am trying to script out the existing replication. When we upgrade, I have to setup the replication after the upgrade.
I can see when...

We don't want to implement this using triggers. This could impact performance.There are lot of tables in the database that needed to be Audited. Is there a in built Audit...