Many time I stuck with a question… what is this DB Server version and what Service pack is installed on it? What is the easiest way to know DB edition? I asked this question to a friend of mine and he gave me the following simple Select statement that answered my questions.
SELECT SERVERPROPERTY(‘productversion’) AS version
, SERVERPROPERTY (‘productlevel’) AS SP
, SERVERPROPERTY (‘edition’) AS DbEdition
I hope you will find it useful 🙂