You'd have to post the code to get help on the WHILE loop. In general, any execution that includes a SELECT or PRINT will return something to the client. Other...

If you have other filegroups, you can also move the table to the other filegroup or set the other as the default.

Do not shrink the database regularly.

Herve has the only real solutions. This isn't tracked by default, so if you haven't enabled anything, you cannot go back in time.

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?