Tres comanditos para saber la versión de SQL server que estamos usando.
SELECT SERVERPROPERTY('productversion')
SELECT SERVERPROPERTY ('productlevel')
SELECT SERVERPROPERTY ('edition')------------------------------------- 10.50.1600.1 (1 row(s) affected) ------------------------------------- RTM (1 row(s) affected) ------------------------------------- Enterprise Edition (64-bit) (1 row(s) affected)
