MSSQL 7 Equivalant of MSSQL200 serverproperty(''servername'') ???

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  March 23, 2005 at 12:31 pm

  #163866

  HI,

  What is the equivalant in MSSQL 7 for the following MSSQL2000 statement:

  select CAST(serverproperty('servername') AS varchar(20))

  Many thanks. Jeff

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  March 23, 2005 at 2:48 pm

  #548607

  Jeff

  select CAST(@@servername as varchar(20))

  Yelena

  Regards,Yelena Varsha