Answers altered, points awarded back to date. Thanks for the corrections.

Probably want to pause the current server so no new users come on and get the other ones to disconnect. Or set to single user mode.

Then do the backup.

Once you...

I think those were the big things. I've heard that quite a few MVPs feel SP2 + CU6 is very stable.

I think you've tackled a lot here and I'll give you a few thoughts on the DW piece.

I think there are companies that build a well designed data warehouse. The...

I think there's a sense of entitlement on both sides in many cases. Too often it seems there are people (management or employees) that don't want to go with the...

I think this is because it overflows beyond 24 and the time spec doesn't show hours > 23.

If you want this converted, I think you need to do the math...

Tend to agree with Mr. Young on this one. You can be right, know it, and be arrogant.

Professional would be doing it, knowing it, using it when needed without making...

Some more info here: http://www.networkworld.com/news/2008/072108-terry-childs-rogue.html

I'd say that if you ever say, or hear someone say, "only xxx can do this", you have a problem. It's OK to have experts, but...

IT is often seen as a cost center, but you can change that to some extent by becoming a strategic group that works to grow the business, increase opportunities, show...

I think you'd need to put the result set into one column, then insert your other into the same column, select out as one big message, and then add as...

Thanks! Glad you liked it, we'll see how everyone else feels in the am.

Looks like it could be Domain Controller issues or Kerberos problems. Can you log onto the remote server from the SQL instance, maybe map a drive from the console?

That's what she said 😛 (http://www.nbc.com/The_Office/)

I am your fearless leader, plowing ahead blindly in the fields of DBA fiefdom. Now let's get back to work.

Sorry for the delayed reply,...

you're welcome and we're trying to sprinkle in some 2008 ones for more information.

the "Select all" has been removed.

I think Grant and Jeff must be related to Dwight Shroot. Sorry you guys lost your privileges to bring nunchakus and stars into the office.