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

I have a few separate accounts, though I don't worry about them too much. We monitor frequently and we're quick to shut down an account if we have issues.

Opting out...

I work for Red Gate, so you know. I'll say that there's no way you could write anything that works as well or reliably as their compare products in anywhere...

What you're asking makes no sense. What do you mean by no shared storage? No SAN-type setup? That severely limits your redundancy.

You can look at Database mirroring, but that...

I'd recommend you just download it again. I've pulled it from Codeplex twice and had no issues, although I did have to get iFTS and Filestream working.

Or use SET IDENTITY_INSERT ON

In either case, you can't use select *, you need to specify columns at least in the INSERT part of the statement.

I think PostgreSQL is a more mature product. But mySQL proves that it can handle loads. The thing is you need the talent that Yahoo and others have, and most...

Check the properties for the database and see if your files are restricted in size or set to autogrow.

Check the recovery model in the same place (is it full or...

Yep, this is code, no need to open each table. You wouldn't do that anyway, the GUI just makes it seem you would.

I'd honestly just use SQLCMD, run them all...

Correct, use admin to install, create a "normal" user with no rights. I'd leave it at everyone in the AD group membership. Then the installation program will assign rights.

I'd recommend...