PeperPeper Posts: 2
edited June 24, 2010 4:02PM in SQL Compare Previous Versions
Is there a way to compare whether options like:

alter database perform set read_committed_snapshot on

and database file settings are the same?


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Chuck,

    SQL Compare can compare objects in a database, but that does not include any dboptions set on the database itself while it's available in a SQL Server Environment.

    You could probably use SQL Server's sp_dboption or DATABASEPROPERTYEX functions to get the values from the databases and compare them.
  • Options
    weswinklerweswinkler Posts: 54 New member
    I routinely use SQL Multi-script to check on general database settings. Just run
    SELECT * FROM sys.databases

    against the master database on different servers, and export the results to Excel.

    It's a snap to scan the individual columns to fiind which databases have particular settings. Condidtional formatting of the Excel file will also quickly highlight any differences from your preferred settings.
Sign In or Register to comment.