Skip to content

Instantly share code, notes, and snippets.

@DarkAllien
Last active January 15, 2018 07:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DarkAllien/cd655363cf8b6dab48cb14efbf77f5be to your computer and use it in GitHub Desktop.
Save DarkAllien/cd655363cf8b6dab48cb14efbf77f5be to your computer and use it in GitHub Desktop.
//——————————————— // SQL 2017 Properties //———————————————
[dynamic, provider("MS_VIEW_INSTANCE_PROVIDER"),
SMS_Report(TRUE),
SMS_Group_Name("SQL 2017 Property"),
SMS_Class_ID("CUSTOM|SQL_2017_Property|2.0")]
class SQL_2017 : SMS_Class_Template
{
[SMS_Report(TRUE) ] Boolean IsReadOnly;
[SMS_Report(TRUE),key] UInt32 PropertyIndex;
[SMS_Report(TRUE),key] String PropertyName;
[SMS_Report(TRUE) ] UInt32 PropertyNumValue;
[SMS_Report(TRUE) ] String PropertyStrValue;
[SMS_Report(TRUE) ] UInt32 PropertyValueType;
[SMS_Report(TRUE),key] String ServiceName;
[SMS_Report(TRUE),key] UInt32 SqlServiceType;
};
//——————————————— // SQL 2016 Properties //———————————————
[dynamic, provider("MS_VIEW_INSTANCE_PROVIDER"),
SMS_Report(TRUE),
SMS_Group_Name("SQL 2016 Property"),
SMS_Class_ID("CUSTOM|SQL_2016_Property|2.0")]
class SQL_2016 : SMS_Class_Template
{
[SMS_Report(TRUE) ] Boolean IsReadOnly;
[SMS_Report(TRUE),key] UInt32 PropertyIndex;
[SMS_Report(TRUE),key] String PropertyName;
[SMS_Report(TRUE) ] UInt32 PropertyNumValue;
[SMS_Report(TRUE) ] String PropertyStrValue;
[SMS_Report(TRUE) ] UInt32 PropertyValueType;
[SMS_Report(TRUE),key] String ServiceName;
[SMS_Report(TRUE),key] UInt32 SqlServiceType;
};
//——————————————— // SQL 2014 Properties //———————————————
[dynamic, provider("MS_VIEW_INSTANCE_PROVIDER"),
SMS_Report(TRUE),
SMS_Group_Name("SQL 2014 Property"),
SMS_Class_ID("CUSTOM|SQL_2014_Property|2.0")]
class SQL_2014 : SMS_Class_Template
{
[SMS_Report(TRUE) ] Boolean IsReadOnly;
[SMS_Report(TRUE),key] UInt32 PropertyIndex;
[SMS_Report(TRUE),key] String PropertyName;
[SMS_Report(TRUE) ] UInt32 PropertyNumValue;
[SMS_Report(TRUE) ] String PropertyStrValue;
[SMS_Report(TRUE) ] UInt32 PropertyValueType;
[SMS_Report(TRUE),key] String ServiceName;
[SMS_Report(TRUE),key] UInt32 SqlServiceType;
};
//——————————————— // SQL 2012 Properties //———————————————
[dynamic, provider("MS_VIEW_INSTANCE_PROVIDER"),
SMS_Report(TRUE),
SMS_Group_Name("SQL 2012 Property"),
SMS_Class_ID("CUSTOM|SQL_2012_Property|2.0")]
class SQL_2012 : SMS_Class_Template
{
[SMS_Report(TRUE) ] Boolean IsReadOnly;
[SMS_Report(TRUE),key] UInt32 PropertyIndex;
[SMS_Report(TRUE),key] String PropertyName;
[SMS_Report(TRUE) ] UInt32 PropertyNumValue;
[SMS_Report(TRUE) ] String PropertyStrValue;
[SMS_Report(TRUE) ] UInt32 PropertyValueType;
[SMS_Report(TRUE),key] String ServiceName;
[SMS_Report(TRUE),key] UInt32 SqlServiceType;
};
//——————————————— // SQL 2008 Properties //———————————————
[dynamic, provider("MS_VIEW_INSTANCE_PROVIDER"),
SMS_Report(TRUE),
SMS_Group_Name("SQL 2008 Property"),
SMS_Class_ID("CUSTOM|SQL_2008_Property|2.0")]
class SQL_2008 : SMS_Class_Template
{
[SMS_Report(TRUE) ] Boolean IsReadOnly;
[SMS_Report(TRUE),key] UInt32 PropertyIndex;
[SMS_Report(TRUE),key] String PropertyName;
[SMS_Report(TRUE) ] UInt32 PropertyNumValue;
[SMS_Report(TRUE) ] String PropertyStrValue;
[SMS_Report(TRUE) ] UInt32 PropertyValueType;
[SMS_Report(TRUE),key] String ServiceName;
[SMS_Report(TRUE),key] UInt32 SqlServiceType;
};
//——————————————— // SQL 2000/2005 Properties //———————————————
[dynamic, provider("MS_VIEW_INSTANCE_PROVIDER"),
SMS_Report(TRUE),
SMS_Group_Name("SQL Legacy Property"),
SMS_Class_ID("CUSTOM|SQL_Legacy_Property|2.0")]
class SQL_2000_And_2005 : SMS_Class_Template
{
[SMS_Report(TRUE) ] Boolean IsReadOnly;
[SMS_Report(TRUE),key] UInt32 PropertyIndex;
[SMS_Report(TRUE),key] String PropertyName;
[SMS_Report(TRUE) ] UInt32 PropertyNumValue;
[SMS_Report(TRUE) ] String PropertyStrValue;
[SMS_Report(TRUE) ] UInt32 PropertyValueType;
[SMS_Report(TRUE),key] String ServiceName;
[SMS_Report(TRUE),key] UInt32 SqlServiceType;
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment