SQL Server

SQLDMO to List SQL Server Configs

Posted on by WARDY IT Solutions

The SQLDMO Script below will list all of the SQL Server configuration options and their config_value and run_value just as per the sp_configure Stored Procedure:

Dim oSQLServer
Dim cvSet oSQLServer = CreateObject(“SQLDMO.SQLServer”)

oSQLServer.LoginSecure = True
oSQLServer.Connect “(local)”

With oSQLServer.Configuration
.ShowAdvancedOptions = True
For Each cv In .ConfigValues
Msgbox cv.Name & “, ” & cv.RunningValue & “, ” & cv.CurrentValue
Next
End With

oSQLServer.DisConnect
Set oSQLServer = Nothing

WARDY IT Solutions

WARDY IT Solutions - Australia's leading SQL Server consultants, trainers and Business Intelligence specialists. WARDY IT Solutions has established itself amongst the top solution providers in SQL Server technologies providing solutions for customers throughout Asia Pacific.