I'm not sure what 7.5 is, from my understanding that was cancelled in favor of 8.0. Nevertheless, the point is there.

Microsoft constantly looks to try and get people to upgrade....

Easy, easy. Go easy on the politics here.

Feel free to start a thread in Not about SQL forum if you wish to debate it.

Glad you liked the question. Something triggered this in my mind and I thought it was a good one.

You have a problem with your model database. Are the model.mdf and model.ldf there?

There isn't a great way to do this. If you have two SQL Servers, you want to back up the HR database separately. You can script or setup a...

A striped backup still requires the full size. If you have the database on multiple file groups, meaning multiple ndf files, you can restore those on separate drives.

Thanks to all of you for helping and I've tried to make this something I'm proud of (as did Andy and Brian when they were here).

We get complaints about the...

My guess is this would get cleaned up over time, but I'd be curious to see.

And I agree with Johan, use a clustered index. Doesn't hurt you to have one.

Not a bad point, we'll talk about adding these in there automatically.

Do we pop external articles in another browser? Do we frame things? I hate frames, BTW.

To me it's not horrible, but it is disappointing in compared to SQLPrompt. It works OK if you don't have anything else, but it's definitely a 1.0 implementation.

The biggest issue...

You're missing the way this works.

WHERE sales > (case when @sales = 'no' then 1 else 0)

THe CASE statement returns a value. That value gets slipped into your WHERE clause....

To me these are things that are daily checks, things you need to make sure are available if you get called when you're on-call. Issues should be documented and also...

You need to post a bit of the code and plan.

What do you mean "safe?"

It works, more and more people running 64-bit every day. There are issues with some subsystems (SQLMail, SSIS), where things could have issues moving to...

You should not be losing any tables, system or user. If some things break, it's because the database reacts differently to keywords, and potentially system views. In 2005/2008 there is...