I don't believe there are scripts anymore, just the downloads from Codeplex.

There are just mdf/ldfs to attach after you unzip them. I'd read the comments for the installer. It seems...

If you mean that you want to add a column, this will work. It will give you an auto-incrementing column for all new rows. However it does not change...

It's interesting to see the responses, and thanks for them.

There's a huge gap between "don't use the cloud" and "put all our systems in the cloud". selective deployment is, IMHO,...

The START command in DOS, and I forget what in *Nix will spawn processes.

One thing I'd do is break my prod pool into 3 groups.

1. One is a "pilot"...

Can you post more information about what parameters you're trying to add, what is or isn't working, and the errors?

Thanks, not sure what's wrong, but I'll log this in the bug system.

Just so we can discuss this with clear terminology. there is no such word as upgradation, and a service pack isn't an upgrade. It's an application of a patch to...

Need to check logs, look for an error of some sort. Could be any number of reasons it's failing.

Are you speaking of SSMS?

I wasn't aware that you could type a new record in the results, and I wouldn't be sure this is a good idea.

This is a...

hadn't thought about client backups, but that's been a big request from me before and sucking out data for one client is a PIA!

One other thing to think about. Andy...

There are some new events in Profiler/Trace to help with this. Otherwise, not sure there's a list. I'll post this around.

I'm with Grant. The DTA gives you a place to start, especially if you're not sure where, but I wouldn't trust it much beyond using it for suggestions that I'd...

This is 32bit, right?

I wonder if SQL Agent has a limitation. Keep in mind that Agent is a separate system from SQL Server. It's a different process.

Most of these products will probably deploy the same way you did, they'll send a script through to SQL Server.

There isn't a shortcut here. Not that I'm pushing you away...

The Inside SQL Server book is a great reference and it talks about this. There are in place updates, which just change the data in row, and there are updates...