SERVERPROPERTY ('xxx')

• Leeland

  SSCrazy Eights

  Points: 8959

  More actions

  February 26, 2009 at 11:42 am

  #95264

  I am looking around the net and cannot find anything or reference to a system stored procedure in SQL 7 that returns server metadata and was wondering if anyone had anything specific? or knew of some sort of T-SQL command that can be run on SQL 7 servers to get metadata out...

  Thanks in advance,

  Lee

• Leeland

  SSCrazy Eights

  Points: 8959

  More actions

  February 26, 2009 at 12:20 pm

  #950765

  Found two procedures that work...

  sp_server_info

  and

  master..xp_msver

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738773

  More actions

  February 26, 2009 at 6:34 pm

  #950926

  Thanks for the note. Do those get what you needed or are you looking for other information?

• Leeland

  SSCrazy Eights

  Points: 8959

  More actions

  February 26, 2009 at 6:52 pm

  #950937

  Steve Jones - Editor (2/26/2009)

  ---

  Thanks for the note. Do those get what you needed or are you looking for other information?

  I was hoping to find something that had a little more information but I don't think there is that much available in SQL 7 as there is in later versions of SQL (which is why I posted)...

  if someone has something to add that would be excellent!