All SQL Version info in one function

  • Wilfred van Dijk

    SSCrazy Eights

    Points: 8969

    Comments posted to this topic are about the item All SQL Version info in one function

    Wilfred
    The best things in life are the simple things

  • dlchase

    Old Hand

    Points: 380

    Does not run. I get messages below.

    Msg 102, Level 15, State 1, Procedure udf_sqlversioninfo, Line 15

    Incorrect syntax near '?'.

    Msg 102, Level 15, State 1, Procedure udf_sqlversioninfo, Line 17

    Incorrect syntax near '?'.

  • Wilfred van Dijk

    SSCrazy Eights

    Points: 8969

    that's probably due to character settings. I suggest to copy the code into an editor and replace strange characters with a space. then it will work.

    Wilfred
    The best things in life are the simple things

  • dlchase

    Old Hand

    Points: 380

    I tried that but got the same result. Thanks.

  • dlchase

    Old Hand

    Points: 380

    I figured it out.

  • karabela33

    SSC Rookie

    Points: 31

    open it with a different editor and youll see 🙂

  • Wilfred van Dijk

    SSCrazy Eights

    Points: 8969

    ** UPDATE **

    I added support for SQL 2000, removed the Licensetype column (according to BOL, this always returns DISABLED) and added columns for Isclustered, FulltextInstalled and HadrStatus (which is a SQL 2012 feature)

    Please let me know for qny issues, comments or suggestions.

    Wilfred
    The best things in life are the simple things

  • Jonathan AC Roberts

    SSCoach

    Points: 17273

    I copied and pasted the function from the article but it wouldn't compile. There were some CHAR(63) in there instead of CHAR(32) (spaces)

  • dav0id

    SSC Enthusiast

    Points: 136

    THankyou for posting - handy function and a good tecnique to group all the required info in one result

  • Wilfred van Dijk

    SSCrazy Eights

    Points: 8969

    That's due to some charset issues when pasting the code into the editor.

    If you copy the code to the clipboard and paste it in an editor like NotePad++, you'll see the goofy characters. Just search/replace those.

    (still don't know how to prevent this issue :ermm: )

    Wilfred
    The best things in life are the simple things

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply