Read from SQL2008 server cluster disk names

[Marnix01]

You can use SQLDMO to read databases and server names, is it possible to read the configuration of a SQL2008 server who have several disks in the cluster and named in the setup of the server ?
I need those names in a vb.net application to setup new servers in the servergroup with scripts so the are all the same for instalation.

 

[jshurst]

From the looks of this article you shouldn't use that.

http://msdn.microsoft.com/en-us/library/ms131540.aspx

I just started using the "Microsoft.SqlServer.Management.Smo" namespace which should be able get you what you need (

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.aspx

).

This doesn't directly relate to your question but here is an example (although I think this was for SQL2005 so I had to modify it):

http://www.codeproject.com/KB/database/SQLScripter.aspx

Regards,

J