Find the Version and Edition of a SQL instance

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…

capture

So:

select serverproperty('productversion'), serverproperty('productlevel'), serverproperty('edition')

Advertisements
Find the Version and Edition of a SQL instance

3 thoughts on “Find the Version and Edition of a SQL instance

  1. 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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s