My experience with replication and DTS (not so much SSIS) is that they work great until they don't. Then it's a pain.

If you are worried about support calls, I'd think...

I've told someone in every interview in the last 9 or so years that I won't be micro-managed and I don't track time. If you need that, hire someone else.

If...

Very good comments and a few smiles appearing over here from the jokes.

Not that I think all british humor is bad, but I don't like the UK version of the...

I might also run a trace for that user and see if anything is happening.

Can you stop the job?

Strange.

If you need to save databases, I'd copy those, then delete the mssql folder structure off the disk. Also in HKLM/Software, delete the Microsoft SQL Server keys. That should let...

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