Blog posts written during November 2009

Astronomically good game!

Thursday Thursday, November 26, 2009 by Ian Pettman

Astronomically good game!

Ever since school I've been interested in astronomy. Even before when my old physics master Dicky Dyson took a group of us one evening to gaze at the moon through a very significant telescope. It seemed as detailed as those images we now see quite frequently on HD television. It was entrancing. Well there is a new game and its one all of us can play. At https://mergers.galaxyzoo.org/ there are a sequence of simulations of galaxies colliding and you choose the best match with an actual collision.  How the universe has grown since my childhood. Back then there was the Andromeda galaxy and maybe (it seemed) a handful of star clusters.  There was, perhaps, an inkling that there were quite a few galaxies, but hundreds of thousands? More to the point millions of them colliding? Enough so you could make a passable representation of the alphabet? Believe it or not this game is actually helpful to our understanding of the universe.

Enjoy the game

Microsoft SQL Server Version Numbers

Friday Friday, November 20, 2009 by Ian Pettman

This code/article has been replaced here

 

For many years we have been able to read the SQL version in use by our agency software. (www.ava.co.uk) This goes back all the way to SQL7.0. From time to time we have scoured the web for information on SQL versions. It all really started with the Tripod entry https://vyaskn.tripod.com/sqlsps.htm and from time to time other resources surfaced: https://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx https://www.sqlteam.com/article/sql-server-versions of course perhaps the least helpful was https://support.microsoft.com/kb/321185 but so what is new? The following script is for the current stored procedure we use to report version numbers for our Help About Window.

 

Please feel free to use, it is provided without any warrantee of any kind. If you do use it please place a link to:  www.ava.co.uk with the words 'Agency software' adjacent to the link on a web site you administer. Thank you

 

 

Code:

 

SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS ON

if exists ( select  * from dbo.sysobjects where id = object_id(N'[dbo].[ap_SQLVersion]')

and OBJECTPROPERTY(id, N'IsProcedure') = 1 )

drop procedure [dbo].[ap_SQLVersion]

GO

 

Create

procedure [dbo].ap_SQLVersion

AS

SET NOCOUNT ON

SELECT

CONVERT(CHAR(25), @@SERVERNAME) AS 'SERVER'

, LTRIM(RTRIM(SUBSTRING(@@VERSION, 22, 5))) AS 'VERSION'

, CASE RTRIM(LTRIM(SUBSTRING(@@VERSION, 22, 5)))

WHEN '6.5' THEN SUBSTRING(@@VERSION, 35, 4)

WHEN '7.00' THEN SUBSTRING(@@VERSION, 35, 4)

WHEN '2000' THEN SUBSTRING(@@VERSION, 35, 4)

WHEN '2005' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('9.00.', @@VERSION) +5 , 5), '.', '')))

WHEN '2008' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('10.0.', @@VERSION) +5 , 5), '.', '')))

END AS 'BUILD'

, CASE RTRIM(LTRIM(SUBSTRING(@@VERSION, 22, 5)))

WHEN '6.5' THEN CASE SUBSTRING(@@VERSION, 35, 4)

WHEN '121' THEN 'NO SP'

WHEN '124' THEN 'SP1'

WHEN '139' THEN 'SP2'

WHEN '151' THEN 'SP3'

WHEN '201' THEN 'NO SP'

WHEN '213' THEN 'SP1'

WHEN '240' THEN 'SP2'

WHEN '252' THEN 'SP3 ** BAD **'

WHEN '258' THEN 'SP3'

WHEN '259' THEN 'SP3 + SBS'

WHEN '281' THEN 'SP4'

WHEN '297' THEN 'SP4 + SBS'

WHEN '339' THEN 'SP4 + Y2K'

WHEN '415' THEN 'SP5 ** BAD **'

WHEN '416' THEN 'SP5a'

WHEN '479' THEN 'SP5a(update)'

ELSE 'Unknown Hot-Fix version or script out of date'

END

WHEN '7.00' THEN CASE SUBSTRING(@@VERSION, 35, 4)

WHEN '1077' THEN 'SP4+Q316333'

WHEN '1063' THEN 'SP4'

WHEN '1004' THEN 'SP3 + Q304851'

WHEN '996' THEN 'SP3 hotfix'

WHEN '978' THEN 'SP3 + Q285870'

WHEN '977' THEN 'SP3 + Q284351'

WHEN '970' THEN 'SP3 + Q283837/282243'

WHEN '961' THEN 'SP3'

WHEN '921' THEN 'SP2 + Q283837'

WHEN '919' THEN 'SP2 + Q282243'

WHEN '918' THEN 'SP2 + Q280380'

WHEN '917' THEN 'SP2 + Q279180'

WHEN '910' THEN 'SP2 + Q275901'

WHEN '905' THEN 'SP2 + Q274266'

WHEN '889' THEN 'SP2 + Q243741'

WHEN '879' THEN 'SP2 + Q281185'

WHEN '857' THEN 'SP2 + Q260346'

WHEN '842' THEN 'SP2'

WHEN '835' THEN 'SP2 Beta'

WHEN '776' THEN 'SP1 + Q258087'

WHEN '770' THEN 'SP1 + Q252905'

WHEN '745' THEN 'SP1 + Q253738'

WHEN '722' THEN 'SP1 + Q239458'

WHEN '699' THEN 'SP1'

WHEN '689' THEN 'SP1 Beta'

WHEN '677' THEN 'MSDE O2K Dev'

WHEN '662' THEN 'Gold+Q232707'

WHEN '658' THEN 'Gold+Q244763'

WHEN '657' THEN 'Gold+Q229875'

WHEN '643' THEN 'Gold+Q220156'

WHEN '623' THEN 'Gold, no SP'

WHEN '583' THEN 'RC1'

WHEN '517' THEN 'Beta 3'

WHEN '416' THEN 'SP5a'

WHEN '415' THEN 'SP5 ** BAD **'

WHEN '339' THEN 'SP4 + y2k'

WHEN '297' THEN 'SP4 + SBS'

WHEN '281' THEN 'SP4'

WHEN '259' THEN 'SP3 + SBS'

WHEN '258' THEN 'SP3'

WHEN '252' THEN 'SP3 ** BAD ** '

WHEN '240' THEN 'SP2'

WHEN '213' THEN 'SP1'

WHEN '201' THEN 'No SP'

WHEN '198' THEN 'Beta 1'

WHEN '151' THEN 'SP3'

WHEN '139' THEN 'SP2'

WHEN '124' THEN 'SP1'

WHEN '121' THEN 'No SP'

ELSE 'Unknown - Hot-Fix version or script out of date'

END

WHEN '2000'

THEN CASE SUBSTRING(@@VERSION, 35, 4)

WHEN '2162' THEN 'SP4 + cumulative hotfix'

WHEN '2159' THEN 'KB 907250 907009'

WHEN '2151' THEN 'KB 903742'

WHEN '2148'

THEN 'KB 902150 898626 895123 899431 901200 899430 901212 900404 902955 900390 903086 900629'

WHEN '2145' THEN 'KB 826906'

WHEN '2040' THEN 'SP4 AWE hotfix'

WHEN '2039' THEN 'Service Pack 4 Downloadable'

WHEN '2026' THEN 'Service Pack 4 (Beta)'

WHEN '1029' THEN 'KB 902851 900625'

WHEN '1027' THEN 'KB 900335'

WHEN '1025' THEN 'KB 899430 899428'

WHEN '1021' THEN 'KB 897578 887700'

WHEN '1020' THEN 'KB 896985'

WHEN '1019' THEN 'KB 897572 896980'

WHEN '1017' THEN 'KB 896425'

WHEN '1014' THEN 'KB 895123 892985'

WHEN '1013' THEN 'KB 891866'

WHEN '1009' THEN 'KB 894254 894257'

WHEN '1007' THEN 'KB 892840 891640 893172 893402 893312 892940'

WHEN '1003' THEN 'KB 892935 892923'

WHEN '1001' THEN 'KB 891707 892310 892551 892205 892141 891719'

WHEN '1000' THEN 'KB 892392 891585'

WHEN '0997' THEN 'KB 891311'

WHEN '0996' THEN 'KB 891017 891201 891268'

WHEN '0994' THEN 'KB 890768 890767 890942'

WHEN '0993' THEN 'KB 888444 890925'

WHEN '0991' THEN 'KB 889314'

WHEN '0990' THEN 'KB 890755 890200'

WHEN '0988' THEN 'KB 889170 890637 889166'

WHEN '0985' THEN 'KB 888998 888429 889239 890730'

WHEN '0980' THEN 'KB 886708 887974'

WHEN '0977' THEN 'KB 889266 884850 885442 843534 884856'

WHEN '0973' THEN 'KB 884554'

WHEN '0972' THEN 'KB 885290'

WHEN '0970' THEN 'KB 884864 885158 884854 884853 884855 872842'

WHEN '0967' THEN 'KB 878501 884772 884260'

WHEN '0962' THEN 'KB 883415'

WHEN '0961' THEN 'KB 873482 875445 872843 873446'

WHEN '0959' THEN 'KB 878500'

WHEN '0957' THEN 'KB 870994'

WHEN '0955' THEN 'KB 867798'

WHEN '0954' THEN 'KB 843282 870972'

WHEN '0952' THEN 'KB 867878 867879 867880 839096'

WHEN '0949' THEN 'KB 867746 843266 843267'

WHEN '0948' THEN 'KB 843263'

WHEN '0944' THEN 'KB 839280'

WHEN '0937' THEN 'KB 841776'

WHEN '0936' THEN 'KB 841627 838409'

WHEN '0935' THEN 'KB 841401'

WHEN '0934' THEN 'KB 841175 841404'

WHEN '0933' THEN 'KB 840406'

WHEN '0929' THEN 'KB 839529'

WHEN '0928' THEN 'KB 840166 839529 839589 839884'

WHEN '0927' THEN 'KB 839688'

WHEN '0926' THEN 'KB 839523 839458'

WHEN '0923' THEN 'KB 839096 838460'

WHEN '0922' THEN 'KB 837231 837970 837969 833045 838459'

WHEN '0919' THEN 'KB 837890 837957'

WHEN '0915' THEN 'KB 837401'

WHEN '0913' THEN 'KB 836839 836651 309802'

WHEN '0911' THEN 'KB 834923 836096 836136 834720'

WHEN '0910' THEN 'KB 834798 835864'

WHEN '0908' THEN 'KB 834290 834688 835581'

WHEN '0904' THEN 'KB 834451 834453'

WHEN '0892' THEN 'KB 833710'

WHEN '0891' THEN 'KB 833406 836141'

WHEN '0879' THEN 'KB 832977'

WHEN '0878' THEN 'KB 838166 832674 832437 831950'

WHEN '0876' THEN 'KB 831997 831999'

WHEN '0873' THEN 'KB 831675 830912 830887 830773'

WHEN '0871' THEN 'KB 829386 830767 830860 831302'

WHEN '0870' THEN 'KB 830262'

WHEN '0869' THEN 'KB 830596 830588'

WHEN '0866' THEN 'KB 830366'

WHEN '0865' THEN 'KB 821537 830382 830375 830395 830298 828945 829183'

WHEN '0863' THEN 'KB 829205 829444'

WHEN '0859' THEN 'KB 821334'

WHEN '0858' THEN 'KB 828637'

WHEN '0857' THEN 'KB 827714 828308 828017'

WHEN '0856' THEN 'KB 828096'

WHEN '0854' THEN 'KB 828699 818079'

WHEN '0852' THEN 'KB 827954 830466'

WHEN '0851' THEN 'KB 827175 826754 827178'

WHEN '0850' THEN 'KB 826906 826815 826860'

WHEN '0848' THEN 'KB 826822'

WHEN '0847' THEN 'KB 826433'

WHEN '0845' THEN 'KB 825854 826364 826376'

WHEN '0844' THEN 'KB 826080'

WHEN '0842' THEN 'KB 825043'

WHEN '0841' THEN 'KB 825225'

WHEN '0840' THEN 'KB 825197 825042 825025 824430 319477 822033'

WHEN '0839' THEN 'KB 824018 824028 824027 823877'

WHEN '0837'

THEN 'KB 820788 823455 825045 821806 822757 822747 822746 822668 821535 821688 821740 820727 823514 824227 825019 821548 819829 823429 825883 825884'

WHEN '0818' THEN 'KB 826161 821277 821688 811188 818806 814919 814950'

WHEN '0816' THEN 'KB 818766 818767 818768 818769 820835 820837 332004'

WHEN '0811' THEN 'KB 819662 818897 819248 819955'

WHEN '0807' THEN 'KB 818899 818335'

WHEN '0804' THEN 'KB 818729'

WHEN '0800' THEN 'KB 817780 818414 818188 818097 818095 816937 818540 828269'

WHEN '0794' THEN 'KB 817464 816440 816883 813524 817709'

WHEN '0789' THEN 'KB 816840 817263 817262 817186 816780 817368 817359 816503 314128'

WHEN '0781' THEN 'KB 815057'

WHEN '0780' THEN 'KB 815056 319477 816084 816069 816039 815593 815592 815114 812915 815183 814997 815476'

WHEN '0775' THEN 'KB 815115'

WHEN '0769' THEN 'KB 815008 814893 815199 814889'

WHEN '0765' THEN 'KB 814509 821548 814654 331158 814894 812995 813494 810688 811611 813769 813759 810163 814460 814916'

WHEN '0763' THEN 'KB 814113'

WHEN '0762' THEN 'KB 814032'

WHEN '760' THEN 'SP3 or SP3a'

WHEN '679' THEN 'SP2 + Q316333'

WHEN '667' THEN 'SP2 + 8/14 fix'

WHEN '665' THEN 'SP2 + 8/8 fix'

WHEN '655' THEN 'SP2 + 7/24 fix (Q323875) *SQLSlammer worm vuln fixed here'

WHEN '650' THEN 'SP2 + Q322853'

WHEN '608' THEN 'SP2 + Q319507'

WHEN '604' THEN 'SP2 + 3/29 fix'

WHEN '578' THEN 'SP2 + Q317979'

WHEN '561' THEN 'SP2 + 1/29 fix'

WHEN '534' THEN 'SP2.01'

WHEN '532' THEN 'SP2'

WHEN '475' THEN 'SP1 + 1/29 fix'

WHEN '452' THEN 'SP1 + Q308547'

WHEN '444' THEN 'SP1 + Q307540/307655'

WHEN '443' THEN 'SP1 + Q307538'

WHEN '428' THEN 'SP1 + Q304850'

WHEN '384' THEN 'SP1'

WHEN '287' THEN 'No SP+Q297209'

WHEN '250' THEN 'No SP+Q291683'

WHEN '249' THEN 'No SP+Q288122'

WHEN '239' THEN 'No SP+Q285290'

WHEN '233' THEN 'No SP+Q282416'

WHEN '231' THEN 'No SP+Q282279'

WHEN '226' THEN 'No SP+Q278239'

WHEN '225' THEN 'No SP+Q281663'

WHEN '223' THEN 'No SP+Q280380'

WHEN '222' THEN 'No SP+Q281769'

WHEN '218' THEN 'No SP+Q279183'

WHEN '217' THEN 'No SP+Q279293/279296'

WHEN '211' THEN 'No SP+Q276329'

WHEN '210' THEN 'No SP+Q275900'

WHEN '205' THEN 'No SP+Q274330'

WHEN '204' THEN 'No SP+Q274329'

WHEN '194' THEN 'RTM No SP'

WHEN '190' THEN 'Gold, no SP'

WHEN '100' THEN 'Beta 2'

WHEN '078' THEN 'EAP5'

WHEN '047' THEN 'EAP4'

ELSE 'Unknown - Hot-Fix version or script out of date'

END

WHEN '2005' THEN CASE RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('9.00.', @@VERSION) +5 , 5), '.', '')))

WHEN '608' THEN 'Beta 1'

WHEN '645' THEN 'Internal'

WHEN '747' THEN 'Internal (IDW1)'

WHEN '767' THEN 'Internal (IDW2)'

WHEN '790' THEN 'Internal (IDW3)'

WHEN '823' THEN 'Internal (IDW4)'

WHEN '836' THEN 'Express Edition Technical Preview'

WHEN '844' THEN 'Internal'

WHEN '849' THEN 'Internal'

WHEN '852' THEN 'Beta 2 '

WHEN '917' THEN 'Internal'

WHEN '951' THEN 'October CTP'

WHEN '981' THEN 'December CTP'

WHEN '1090' THEN 'March CTP (Doc as Feb)'

WHEN '1116' THEN 'April CTP'

WHEN '1187' THEN 'June CTP'

WHEN '1314' THEN 'September'

WHEN '1399' THEN 'RTM '

WHEN '1500' THEN 'RTM +KB 910414 910416 910419'

WHEN '2047' THEN 'SP1'

WHEN '3042' THEN 'SP2 needs hot fix'

WHEN '3043' THEN 'SP2 +MaintenancePlanTasks.dll'

WHEN '3044' THEN 'SP2 +GRD2'

WHEN '3050' THEN 'SP2 +GRD1'

WHEN '3052' THEN 'SP2 +933097'

WHEN '3054' THEN 'SP2 +934458'

WHEN '3059' THEN 'SP2 +934459'

WHEN '4266' THEN 'SP3 + Q974648 (Cumulative HF6)'

WHEN '4230' THEN 'SP3 + Q972511 (Cumulative HF5)'

WHEN '4226' THEN 'SP3 + Q970279 (Cumulative HF4)'

WHEN '4224' THEN 'SP3 + Q971409'

WHEN '4220' THEN 'SP3 + Q967909 (Cumulative HF3)'

WHEN '4216' THEN 'SP3 + Q967101'

WHEN '4211' THEN 'SP3 + Q961930 (Cumulative HF2)'

WHEN '4207' THEN 'SP3 + Q959195 (Cumulative HF1)'

WHEN '4035' THEN 'SP3 + Q955706'

WHEN '4053' THEN 'SP2 Express advanced services'

WHEN '3355' THEN 'SP2 + Q216793 (Cumulative HF16)'

WHEN '3330' THEN 'SP2 + Q972510 (Cumulative HF15)'

WHEN '3328' THEN 'SP2 + Q970278 (Cumulative HF14)'

WHEN '3327' THEN 'SP2 + Q948567 / 961648'

WHEN '3325' THEN 'SP2 + Q967908 (Cumulative HF 13)'

WHEN '3320' THEN 'SP2 + Q969142'

WHEN '3318' THEN 'SP2 + Q967199'

WHEN '3315' THEN 'SP2 + Q962970 (Cumulative HF12, available via request.)'

WHEN '3310' THEN 'SP2 + Q960090'

WHEN '3303' THEN 'SP2 + Q962209'

WHEN '3302' THEN 'SP2 + Q961479 / 961648'

WHEN '3301' THEN 'SP2 + Q958735 (Cumulative HF11, avail. via request.)'

WHEN '3295' THEN 'SP2 + Q959132'

WHEN '3294' THEN 'SP2 + Q956854 (Cumulative HF10, avail. via request.)'

WHEN '3291' THEN 'SP2 + Q956889'

WHEN '3289' THEN 'SP2 + Q937137'

WHEN '3282' THEN 'SP2 + Q953752 / 953607 (Cumulative HF9, avail. via request.)'

WHEN '3261' THEN 'SP2 + Q955754'

WHEN '3260' THEN 'SP2 + Q954950'

WHEN '3259' THEN 'SP2 + Q954669 / 954831'

WHEN '3257' THEN 'SP2 + Q951217 (Cumulative HF8, avail. via request.)'

WHEN '3253' THEN 'SP2 + Q954054'

WHEN '3244' THEN 'SP2 + Q952330'

WHEN '3242' THEN 'SP2 + Q951190'

WHEN '3240' THEN 'SP2 + Q951204'

WHEN '3239' THEN 'SP2 + Q949095 (Cumulative HF7, avail. via PSS only)'

WHEN '3235' THEN 'SP2 + Q950189'

WHEN '3233' THEN '(QFE) SP2 + Q941203 / 948108'

WHEN '3232' THEN 'SP2 + Q949959'

WHEN '3231' THEN 'SP2 + Q949687/949595'

WHEN '3230' THEN 'SP2 + Q949199'

WHEN '3228' THEN 'SP2 + Q946608 (Cumulative HF6, avail. via PSS only)'

WHEN '3224' THEN 'SP2 + Q947463'

WHEN '3222' THEN 'SP2 + Q945640 / 945641 / 947196 / 947197'

WHEN '3221' THEN 'SP2 + Q942908 / 945442 / 945443 / 945916 / 944358 '

WHEN '3215' THEN 'SP2 + Q941450 (Cumulative HF5, avail. via PSS only)'

WHEN '3209' THEN 'SP2 (KB N/A, SQLHF Bug #50002118)'

WHEN '3208' THEN 'SP2 + Q944902'

WHEN '3206' THEN 'SP2 + Q944677'

WHEN '3205' THEN 'SP2 (KB N/A, SQLHF Bug #50001708/50001999)'

WHEN '3203' THEN 'SP2 (KB N/A, SQLHF Bug #50001951/50001993/50001997/50001998/50002000)'

WHEN '3200' THEN 'SP2 + Q941450 (Cumulative HF4, avail. via PSS only)'

WHEN '3195' THEN 'SP2 (KB N/A, SQLHF Bug #50001812)'

WHEN '3194' THEN 'SP2 + Q940933'

WHEN '3186' THEN 'SP2 + Q939562 (Cumulative HF3, avail. via PSS only)'

WHEN '3182' THEN 'SP2 + Q940128'

WHEN '3180' THEN 'SP2 + Q939942'

WHEN '3179' THEN 'SP2 + Q938243'

WHEN '3178' THEN 'SP2 (KB N/A, SQLHF Bug #50001193/5001352)'

WHEN '3177' THEN 'SP2 + Q939563 / 939285'

WHEN '3175' THEN 'SP2 + Q936305 /938825 (Cumulative HF2, avail. via PSS only)'

WHEN '3171' THEN 'SP2 + Q937745'

WHEN '3169' THEN 'SP2 + Q937041/937033'

WHEN '3166' THEN 'SP2 + Q936185 / 934734'

WHEN '3162' THEN 'SP2 + Q932610/935360/935922'

WHEN '3161' THEN 'SP2 + Q935356/933724(Cumulative HF1, avail. via PSS only)'

WHEN '3159' THEN 'SP2 + Q934459'

WHEN '3156' THEN 'SP2 + Q934226'

WHEN '3155' THEN 'SP2 + Q933549 / 933766/933808/933724/932115/933499'

WHEN '3154' THEN 'SP2 + Q934106 / 934109 / 934188'

WHEN '3153' THEN 'SP2 + Q933564'

WHEN '3152' THEN 'SP2 + Q933097 (Cumulative HF1)'

WHEN '3077' THEN 'SP2 + Q960089'

WHEN '3073' THEN 'SP2 + Q954606 (GDR)'

WHEN '3068' THEN '(GDR) SP2 + Q941203 / 948109'

WHEN '3054' THEN 'SP2 + Q934458'

WHEN '3050' THEN 'SP2 + Q933508'

WHEN '3043' THEN 'SP2 + Q933508 (use this if SP2 was applied prior to 3/8)'

WHEN '3042' THEN 'Fixed SP2 (use this if SP2 was NOT applied yet - orig. RTM removed)'

WHEN '3033' THEN 'SP2 CTP (December) - Fix List'

WHEN '3027' THEN 'SP2 CTP (November)'

WHEN '3026' THEN 'SP1 + Q929376'

END

WHEN '2008' THEN CASE RTRIM(LT

RIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('10.0.', @@VERSION) +5 , 5), '.', '')))

WHEN '1019' THEN 'June CTP'

WHEN '1049' THEN 'July CTP (requires Virtual Server 2005 R2)'

WHEN '1300' THEN 'February CTP'

WHEN '1600' THEN 'RTM'

WHEN '1750' THEN 'RTM + Q956718)'

WHEN '1771' THEN 'RTM + Q958611)'

WHEN '1779' THEN 'RTM + Q958186 Cumulative HF2, available by request.'

WHEN '1787' THEN 'RTM + Cumulative Update 3'

WHEN '1798' THEN 'RTM + Cumulative Update 4'

WHEN '1806' THEN 'RTM + Cumulative Update 5'

WHEN '1812' THEN 'RTM + Cumulative Update 6'

WHEN '2531' THEN 'Service Pack 1'

WHEN '2710' THEN 'SP1 + Cumulative Update 1'

WHEN '2712' THEN 'SP1 + Q970507'

WHEN '2714' THEN 'SP1 + Cumulative Update 2'

WHEN '2723' THEN 'SP1 + Cumulative Update 3'

WHEN '2734' THEN 'SP1 + Cumulative Update 4'

END

END AS 'SP'

, CASE RTRIM(LTRIM(SUBSTRING(@@VERSION, 22, 5)))

WHEN '6.5' THEN SUBSTRING(@@VERSION, 30, 4)

WHEN '7.00' THEN SUBSTRING(@@VERSION, 30, 3)

WHEN '2000' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('8.', @@VERSION) +2 , 3), '.', '')))

WHEN '2005' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('9.', @@VERSION) +2 , 3), '.', '')))

WHEN '2008' THEN RTRIM(LTRIM(REPLACE(SUBSTRING(@@VERSION, CHARINDEX('10.', @@VERSION) +3 , 2), '.', '')))

END AS 'VER'

 

SET NOCOUNT OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

--test

--exec ap_SQLVersion

 

 

Vista Create IIS folder

Tuesday Tuesday, November 03, 2009 by Ian Pettman

There is a new how to article on server set up for Vista IIS or create a web application folder

Contact Information

To find out more about Ava solutions you can contact us in a number of ways:
Follow Us...