HOW TO find SQL Server edition info

While deploying applications, you may require details of the SQL Server edition or other properties, like I did when I had to find if the latest Service Packs were installed and this function is useful to know:

SELECT SERVERPROPERTY('ProductLevel')

Edition
ProductVersion
ServerName
Collation
Engine Edition
InstanceName
IsClustered
IsFullTextInstalled
IsIntegratedSecurityOnly
IsSingleUser
IsSyncWithBackup
LicenseType
MachineName
NumLicenses
ProcessID

Comments

Popular posts from this blog

A Beginner's Guide to Data & Analytics - Highlights

Oracle Cloud Infrastructure 2024 Generative AI Professional Course & Certification Exam (1Z0-1127-24)

AI - Reflections & Perspectives