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

Do you mean you are using SSMS to save the data?

This produces a text file and the CR/LF should be there.

There are some clustering videos at JumpstartTV as well:

http://www.jumpstarttv.com/channel.aspx?cat=4a00c49a-6207-4ba8-952c-807481629761

Look at PIVOT or a cross tab report.

It's not an easy thing to do, especially as what do you do with multiple rows? Are they extended to the right?

I'm not sure that there is a business reason to upgrade to 2008 from 2005. There aren't a lot of new features, and the new ones, for the most part...

The import/export wizard is designed to ad hoc import a file, not process lots of files. When you run the import/export wizard, you can build an SSIS package as the...