Is Fulltext Installed
14. 10. 2024
Is External Authentication Only
19. 4. 2023
Returns whether Azure AD-only authentication is enabled. Applies to: Azure SQL Database and Azure SQL Managed Instance.
Is Case Sensitive
19. 4. 2023
Returns 1 if the default instance collation is case sensitive.
Is Big Data Cluster
19. 4. 2023
Returns 1 if the instance is SQL Server Big Data Cluster; 0 if not.
Is Advanced Analytics Installed
19. 4. 2023
Returns 1 if the Advanced Analytics feature was installed during setup; 0 if Advanced Analytics was not installed.
Instance Name
19. 4. 2023
Name of the instance to which the user is connected. Returns NULL if the instance name is the default instance.
Host Service Pack Level
16. 4. 2023
Service pack level of the Windows operating system. For Linux, returns an empty string.