DB Schema version Info

• harish224227

  SSC Veteran

  Points: 259

  More actions

  July 22, 2009 at 1:35 am

  #223866

  HI all

  I want to get the Schema version info for a DB.

  Help me in resolving it

  Thanks

• Ysaias Portes-QUI Group

  SSCrazy

  Points: 2127

  More actions

  April 11, 2011 at 11:00 am

  #1309960

  You can use the sp_helpdb stored procedure or query the sys.databases system table

  sp_helpdb 'master'

  GO

  SELECT * FROM sys.databases WHERE name ='master'

  GO

  QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809

• Maksymilian Mulawa

  Ten Centuries

  Points: 1336

  More actions

  April 11, 2011 at 1:05 pm

  #1310047

  SQL Server as a product has versions, you can view it by calling following functions.

  SELECT @@VERSION

  Could you be more specific to what version you are referring to, as schemas in SQL Server database are not being versioned?

  Cheers, Max

  Check-out free open-source utility Sql Server Replication Explorer[/url]