All good points, I couldn't put it any better than that.

LOL 😀

It could be doing alot of reindexing! That could be the source of your problem?

This is nothing new as far as technology goes even Windows Server has something similiar to replicate volumes to new volumes! I can't think of what it is called...

I used exclusively RAID 1 for all my TempDB's, which I think is the best for performance without the single point of failure factor!

Let me know what you find out? We don't use CR but I know a few clients that this can be useful!

Have you put in a Crystal Report v9 in...

Good info...

We don't use sa account at all and have deleted that account! We do have a Windows Group that has sa priviledges. So the few members of that group...

I agree.... This has an old school feel to it! Yeah use the new 2005 proc's

That is why I love SQL Server, you have so many options to do the same thing and it just comes down to your personal preference in handling the task.

Your absolutely right Steve!:-D

We use just what is built into SQL Server Alerts. I have about 25 alerts that is scripted and whenever we have a new server built we apply the scripts....

Yes, they are single mdf and ldf databases! Also split up on seperate volumes as well, my log files are all together while my mdf's are on multiple volumes.

I...

Hey Jack, I definately agree with your view point! Right on the Money!!!

Is there a reason why you didn't use SQL Security and let that control the execution of your package?