Get Sql Server major version number from serverproperty function

More for me than for you.  I’ve written and re-written this about 6 times this week and can’t seem to remember to save it off, so here I go.  This will return the major version number for the sql server being queried.  Sql Server 2000 = 8, Sql Server 2005 = 9, etc…


Leave a Reply

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

You are commenting using your 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.