What Version of SQL Server Am I Running?

How often do you find yourself thinking “what version of sql server am I running?”. I bet, it happened more than once… If so, you might find this what version of sql server am I running query quite useful: SELECT substring(@@VERSION,1,26) + ‘ (‘ + — Full SQL Version + CAST(SERVERPROPERTY(‘productversion’) AS VARCHAR) + ‘) […]