Post reply

DB Schema version Info

  • 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

  • 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

  • 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]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply