Thank you very much Guys......... It helps me a lot.

Sorry one one answered.

There is topic in books online to make partition automatic.

hope you understand my scenario.

As new quarter started 1st partition should be deleted and new quarter should be added automatically. There...

I have a table partitioned by 8 quarters. (partition on datetime column.). In that table i just want to maintain 2 yrs data only and also want it automatic.

...

As of now i wasn't told for what this tool is for. My team lead wanted me to find a best tool to read T-Log and it's price. Once i...

To monitor the transactions. No matter what cost it is. Can you please tell me a list of Transaction log reader tools?

Thank you for reply. i couldn't find in Books online. can you please write code for me to delete quarter data and add new partition automatically.

Can you explain me how to create a job to add and delete partitions automatically?