Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

All SQL Version info in one function Expand / Collapse
Author
Message
Posted Thursday, April 5, 2012 8:48 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:14 AM
Points: 930, Visits: 1,132
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
Posted Saturday, April 7, 2012 6:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 6:24 AM
Points: 8, Visits: 62
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
Posted Saturday, April 7, 2012 2:50 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:14 AM
Points: 930, Visits: 1,132
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
Posted Sunday, April 8, 2012 6:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 6:24 AM
Points: 8, Visits: 62
I tried that but got the same result. Thanks.
Post #1279973
Posted Sunday, April 8, 2012 6:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 6:24 AM
Points: 8, Visits: 62
I figured it out.
Post #1279974
Posted Wednesday, May 2, 2012 6:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 12, 2014 7:10 AM
Points: 7, Visits: 37
open it with a different editor and youll see :)
Post #1293785
Posted Tuesday, May 8, 2012 12:10 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:14 AM
Points: 930, Visits: 1,132
** 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
Posted Monday, May 28, 2012 4:12 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:38 AM
Points: 338, Visits: 1,426
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
Posted Monday, May 28, 2012 10:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 5, Visits: 283
THankyou for posting - handy function and a good tecnique to group all the required info in one result
Post #1307497
Posted Tuesday, May 29, 2012 7:39 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:14 AM
Points: 930, Visits: 1,132
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 )


Wilfred
The best things in life are the simple things
Post #1307775
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse