Pages

Thursday 20 August 2009

What version of SQL Server are you running?

I've added a new facility to identify how patched your instance of SQL Server is;

1) Find out your SQL Server version - if you don't know, here is a link to the Microsoft site that will tell you how to.

2) Go to the following "SQL Server Version List" web page.

3) Enter your version number in to the box.

Easy as that!!

Useful SQL:

SELECT @@Version

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

at 08:17

3 comments:

  1. Ṭọḳạ8 September 2009 at 10:51

    Hi, very nice and useful tool!
    I love it.
    I counld not download desktop version thoug, I get 404 - File or directory not found error.
    Please correct it.

    ReplyDelete
  2. Ṭọḳạ8 September 2009 at 10:55

    It would be a great feature if the comments were preserved

    ReplyDelete
  3. Mark Pryce-Maher23 September 2009 at 16:49

    Sorry, I have fixed the 404 error - I found that they were deleted by mistake!!! SORRY!

    Also I have been working on getting comments preserved.

    I've been working on the SQL Server add-in. Which has now been released here - http://www.tsqltidy.com/beta/tsqltidySSMSAddin.aspx

    ReplyDelete

Subscribe to: Post Comments (Atom)