Posted by John Bell on 12/28/06 12:20

Hi

You can test the version you are using and make the code run conditional on
that setting such as

IF CAST(LEFT(CAST(SERVERPROPERTY('productversion') AS varchar(30)),1) AS
smallint) < 9 GOTO EndofScript
PRINT CAST(LEFT(CAST(SERVERPROPERTY('productversion') AS varchar(30)),1) AS
smallint)
EndofScript:

John

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:4592d4b6$0$31237$da0feed9@news.zen.co.uk...
> Hi
>
> The SERVERPROPERTY function will give you similar information see
> http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
>
> John
>
> "fireball" <fireball@onet.kropka.eu> wrote in message
> news:emu0hh$opo$1@atlantis.news.tpi.pl...
>>I need to test, wheather my scripts run under proper instance version (ie.
>>if it is 2005).
>> I only know @@VERSION, but taht's not it. Any suggestions?
>>
>>
>>
>
>

[Back to original message]