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