April 5, 2012 at 8:48 pm
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
April 7, 2012 at 6:50 am
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 '?'.
April 7, 2012 at 2:50 pm
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
April 8, 2012 at 6:39 am
I tried that but got the same result. Thanks.
April 8, 2012 at 6:43 am
I figured it out.
May 2, 2012 at 6:51 am
open it with a different editor and youll see
May 8, 2012 at 12:10 pm
** 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
May 28, 2012 at 4:12 am
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)
May 28, 2012 at 10:02 pm
THankyou for posting - handy function and a good tecnique to group all the required info in one result
May 29, 2012 at 7:39 am
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 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy