SQL Server Performance

@@version year

Discussion in 'SQL Server 2008 General Developer Questions' started by i.netdeveloper, Jul 15, 2010.

  1. Hi, I want to a script based on sql server version year, because some objects are not supported in 2000. We have two enviorments.
    something like
    if @@version = 'Microsoft Sqlserver 2000'
    --do this
    if @@version ='Microsoft Sqlserver 2008'
    -- do this
    I really appreciate your help.
    Thanks...
  2. Adriaan New Member

  3. satya Moderator

    This is locked.

Share This Page