Thanks Guys ! By adding the Allians and moving the conditions on ACTION_TYPE_ID and GROUP_ID out of the WHERE clause and into the LEFT JOIN works for me. Again Thanks...

Thanks a lot of the reply guys!

Thanks! I will try it and let you know by the result.... Thanks Again..

Thanks for your reply.

I tried to just use Disk only in GroupBy clause but it error out to add me other colmun as a part of group by...

Can you give...

Thanks All...

There are no such a document... Just they told me the way application will work..

Great post,

But i have a problem that i am receving the emails with empty Attachment and also what is the Schedule for Sql Agent Job?

l

ogdate ...

I am really Thanks full to you. Finally i did it.

Once Again !!

Thanks John for your time and efforts.

John, I did the same thing but no luck..

I dont know how to change the package level variables to dynamically change your Source DB

with in the For...

Thanks John. I was doing some thing but you have me good approch. Let me try and i'll let you know by the results.

Thanks. Arman

I can do the 2nd Step while using the SQL Task. But i dont knonw that how i can move the data which i mention in Step 1.

I have two below tables which are the main cause and i check the Execution Plan and mostly we are getting table & indexd scans. Please advise me that...

Thanks Gila, Thats what i did earlier and found few queries which were taking most of the CPU. There is a need of indexes on them.

I just post this Question...

Thanks to All of You !!

Just answer your questions.

This is sql server 2000/sp4.The database is about 40GB. I am taking transaction log after every 2 hrs and after every 10...