Thanks. Much appreciated.

Gail, how do you obtain the command line options for a DTS package?

I can't find a way to do it in EM but you can use "sp_changedbowner". Check out BOL. Also, watch the forum that you're posting to. This is SQL 2005...

Agreed. Thanks for your help.

I have something similar to what you've created (I'll admit, your's is better looking!) using two cursors, one for the database and then one for the table names.

Then I...

I got it. Not sure if this is the best (or even proper) method, but it works. Thanks for the MIN suggestion. Sometimes I tend to over complicate things and...

Ok, I have the query to return the MIN date. How (if) do I return the new date as desired within this select? Of course it's telling me in not...

I'd go with a view as suggested earlier by rbarryyoung. Something like this will handle multiple rows for the User_ID. And, best of all, no triggers or additional work. The...

I found this somewhere (here maybe?) a while ago. Modify it to suit your needs but it shows me exactly what I'm looking for. We use NetBackup for some databases...

FYI - For quicker, more accurate responses, be aware of which forums you post to, this is for SQL2K5. :rolleyes:

At my previous employer we used an ELM tool from tntsoftware.com It allowed us to monitor the event logs and send emails for various items. The drawback was, initially, we...

The follow ups are absolutely correct. As Ed stated, in depends on your site, but I'll add, also you application(s). At my previous employer, our payroll app had a much...

The site is back up!!!

http://www.fullsun.net/

Thanks to all for your suggestions. I went with Matt's design since it'll keep the query running optimally as the data grows. Much appreciated.

Sweet, an easy 5 points! Does anyone believe M$ is going to do this anytime soon? It would be nice to have but with the cash register constantly chiming for...