SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by wfvdijk / All SQL Version info in one function / Latest Posts

RE: All SQL Version info in one function

Wilfred van Dijk — Tue, 29 May 2012 07:39:20 GMT

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

RE: All SQL Version info in one function

dav0id — Mon, 28 May 2012 22:02:20 GMT

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

RE: All SQL Version info in one function

Jonathan AC Roberts — Mon, 28 May 2012 04:12:54 GMT

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)

RE: All SQL Version info in one function

Wilfred van Dijk — Tue, 08 May 2012 12:10:53 GMT

[b]** UPDATE **[/b]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.

RE: All SQL Version info in one function

karabela33 — Wed, 02 May 2012 06:51:38 GMT

open it with a different editor and youll see :)

RE: All SQL Version info in one function

dlchase — Sun, 08 Apr 2012 06:43:09 GMT

I figured it out.

RE: All SQL Version info in one function

dlchase — Sun, 08 Apr 2012 06:39:27 GMT

I tried that but got the same result. Thanks.

RE: All SQL Version info in one function

Wilfred van Dijk — Sat, 07 Apr 2012 14:50:53 GMT

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.

RE: All SQL Version info in one function

dlchase — Sat, 07 Apr 2012 06:50:50 GMT

Does not run. I get messages below.Msg 102, Level 15, State 1, Procedure udf_sqlversioninfo, Line 15Incorrect syntax near ' '.Msg 102, Level 15, State 1, Procedure udf_sqlversioninfo, Line 17Incorrect syntax near ' '.

All SQL Version info in one function

Wilfred van Dijk — Thu, 05 Apr 2012 20:48:40 GMT

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