How can we help you today? How can we help you today?

features

Is there a way to compare whether options like:

alter database perform set read_committed_snapshot on

and database file settings are the same?
Peper
0

Comments

2 comments

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0
  • weswinkler
    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.
    weswinkler
    0

Add comment

Please sign in to leave a comment.