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 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply