All SQL Version info in one function

  • 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

  • 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 '?'.

  • 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

  • I tried that but got the same result. Thanks.

  • I figured it out.

  • open it with a different editor and youll see 🙂

  • ** 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

  • 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)

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

  • 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