Extend SERVERPROPERTY() to Feature-level - by SAinCA

Status : 


Sign in
to vote
ID 3111773 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 11/16/2016 3:37:52 PM
Access Restriction Public


With SQL2016 Enterprise Features being made available in Standard Edition as of SP1, the ability to determine which "Enterprise" features are present from with SQL changes from simply using  SERVERPROPERTY('EngineEdition') IN ( 3, 5, 6 ) to having to compare the Build Number to be > 13.0.4001 to become aware of, for example DATA_COMPRESSION being available.
Sign in to post a comment.