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...

As far as feedback goes, especially with Connect being the main source of bugs/issues with all MS products, here are a few items.

Items (all status, open or closed) with >...

I believe this is because there is old code here that changes DST at a later time in the UK. I'll have to see if we can get this patched.