Thanks Alan,

my mistake! To complete your answer, MSDN says:

"Visual FoxPro ODBC Driver

The VFPODBC driver is no longer supported. We strongly recommend using the Visual FoxPro OLE DB provider as a...

Doh! And me who was focusing on the article content while there was such a weird...

Dear Todd,

thank you for your article focusing on SQL Server security vulnerabilities. I would like to put the stress on a couple of points.

First your long list of vulnerabilities can...

I update this old thread because it is of no use without an answer to the question:

The [msdb].[dbo].[sp_dts_getfolder] is actually changed to [msdb].[dbo].[sp_ssis_getfolder]

as naming conventions changed because "DTS" is...

Hi Tim, Please use the "Report" button to report the spam to the Moderator and allow him to do some clean up. I Already did it for these two §£$##@%ç!!...

Hello everybody!

This is really a nice article, very well written and I am really, really sorry about the info I will bring below:

Microsoft is changing all the SQL Server...

Hi Alejandro, thanks a lot for sharing this, this is an interesting article. Will you publish a "Part 2" ? I am preparing an important cluster upgrade and I would...

Yes, the Idera Tools are neat but they need to install components (SQL-DMO and SQL 2005 backwards compatibility) that might not be allowed in production servers: a script is a...

Thanks for sharing your script.

I would add another possible critical point: as this script's use could also be to be run against all databases for Disaster Recovery purposes, you...

Correct. I overlooked that point, thanks for precising that. That's one more reason to avoid 3 node SQL clusters!

@forsqlserver

From a cluster/SQL setup point of view, adding a third node is not very complicated: you join the new node to the existing cluster and you add a SQL...

Thanks Calvo! The goal was to share an experience and try to easy someone's life if they should get into these issues. I'll try to share some more in the...

@Prowlermax,

I have not upgraded a Cluster to SQL2008R2 yet. I should upgrade a SQL 2005 to SQL 2008R2 in the next two months and my plan is to:

1.Full...

Dev suggestion of using mirroring instead of clustering could be an interesting alternative to cluetring, especially in case you do not have a SAN available.

Getting back to Low Rider's request...

To give some more information I would add that:

1.Microsoft does not provide Active/Active clusters but only Active/Passive clusters, also more properly called in MS lingo "Failover Clusters". That means that...