All SQL Version info in one function

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by wfvdijk » All SQL Version info in one function

All SQL Version info in one function

Rate Topic

Display Mode

Topic Options

Author

Message

Wilfred van Dijk

Posted Thursday, April 05, 2012 8:48 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 898, Visits: 1,049

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

Post #1279299

dlchase

Posted Saturday, April 07, 2012 6:50 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 3:15 PM
Points: 7, Visits: 48

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

Post #1279821

Wilfred van Dijk

Posted Saturday, April 07, 2012 2:50 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 898, Visits: 1,049

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

Post #1279899

dlchase

Posted Sunday, April 08, 2012 6:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 3:15 PM
Points: 7, Visits: 48

I tried that but got the same result. Thanks.

Post #1279973

dlchase

Posted Sunday, April 08, 2012 6:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 3:15 PM
Points: 7, Visits: 48

I figured it out.

Post #1279974

karabela33

Posted Wednesday, May 02, 2012 6:51 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 12:10 AM
Points: 2, Visits: 27

open it with a different editor and youll see :)

Post #1293785

Wilfred van Dijk

Posted Tuesday, May 08, 2012 12:10 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 898, Visits: 1,049

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

Post #1296671

Jonathan AC Roberts

Posted Monday, May 28, 2012 4:12 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 6:48 PM
Points: 321, Visits: 1,218

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)

Post #1307201

dav0id

Posted Monday, May 28, 2012 10:02 PM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 3:50 AM
Points: 5, Visits: 231

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

Post #1307497

Wilfred van Dijk

Posted Tuesday, May 29, 2012 7:39 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, June 10, 2013 7:21 AM
Points: 898, Visits: 1,049

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

Post #1307775

« Prev Topic | Next Topic »

Permissions