I’ve got a lot of Virtual Machines for development, and that means a lot of SQL installs. They’re not all the same edition, though, or versions, or service packs. It can be a bit confusing knowing which one I’m dealing with. And I can never remember how to find out – so here is the reminder…
So:
select serverproperty('productversion'), serverproperty('productlevel'), serverproperty('edition')
… and a little bit deeper:
USE master
EXEC xp_msver; — without optname for the whole result
GO
CU
tosc
Cool tip. Still like the first query, ‘cos it tells me the edition and level more obviously, but the stored procedure you’ve mentioned gives a lot more information about the environment
CU
tosc