I would say the quickest way to do it would be to generate a series of dtuil scripts for each package, dump them into a .bat file and execute that....

Thanks!! That is perfect.

I didn't realize you could use case statements like that to get the aggregate counts.

This is interesting, definitely something for the vault.

Thanks again!

Steve

Instead of "DEFAULT", I would say it's the instance's name. I don't know that first-hand though.

We have teamed NIC's on just about all of our clusters where I work, and I personally haven't experienced any problems leaving them teamed for the SQL install. I've...

Guess I should open a case with MS?

As MC suggests, you'll need to modify the logic of the SP that you're passing the parameters to.

If you're just using a SQL query, I would change it to...

Have you been able to get the logins added to SQL Server successfully? I have tried the same scenario in the past with no luck by using local windows...

I apologize if I missed some of the information posted earlier, but as a general practice when upgrading, we do the following at my company:

1. DBCC CHECKDB([dbname]) with data_purity

2. DBCC...

No one has experienced this issue?

mflynn-549529 (12/7/2009)

---

One gotcha that got us was testing 2005 databases.

The test we wanted to do was see how a large database performed on the new 2008 machine. ...

I don't think this statement is truly...

I would open a case with Red Gate for this- it's not something I have seen before, and they are up to at least version 8.1 of the application, so...

For starters: the syspolicy_purge_history job -- needs to be updated for the virtual server name of the sql instance; if you install node A on the D:\program files\... path,...

If you have VS already installed, you'll need SP1 to proceed. No need to install VS 2008 just for the SQL install.

Hope that helps.

Great little article, and the gotcha...

make sure the sql agent is disabled, that can take up a connection.

hope that helps,

Steve