You could schedule a job to run after the maintenance plan (or add a step) that runs this for a backup and then parse the results.

The maintenance plan should have...

It's likely some data issue. Have you checked to see if there are formulas or calculations that might be data dependent? Meaning something like a divide by 0 is occurring.

Do not cross post.

Answered here: http://www.sqlservercentral.com/Forums/Topic468000-1063-1.aspx

You have issued a "SELECT", which expects results to be returned back. however your script does an insert and doesn't return any results.

Only issue is space on the C: drive. Lots of stuff wants to be there, including SQL patches. The error logs can grow, so potentially you'd move them (service parameter),...

Are you looking for common firstname and lastname between the tables, meaning that you want to know if "John Smith" is in both tables?

Or do you want matching names between...

Late to the party and maybe I missed it, but tempdb has nothing to do with logging. Completely separate.

Good advice from Matt and Jeff and I'd agree with it.

Also, shrinking...

Search Maximum Capacity Specifications in Books online (or google).

Some of these will change in SS2k8

Or urn Profiler, look for insert/udpate/delete stuff, save the file for a day and scroll through it at a meeting. Set your scroll to move slow and let it run...

Adam has hit it on the head. It's a security issue.

Check the rights on the Sales table and then who is running the package?

I think memory even with WOW, is a little better. Are you running Enterprise SQL?

Also, think about Win 2008 now. It's just out, so a longer life cycle for the...

It's a good magazine. A little different focus than here, more higher end, some more theory stuff. Itzak Ben Gan and Kalen Delaney, two very talented DBAs, write columns there....

What is the error?

not sure what the best solution is here. I don't know of anything that specializes in this, but if you have Exchange, you can set up public calendars. Maybe one...

I'm not sure I agree that the value or enhancements with 2005 aren't significant for the price increase. Don't forget inflation as well, so over 5 years, I'd expect some...