features

Peper

Is there a way to compare whether options like:

alter database perform set read_committed_snapshot on

and database file settings are the same?

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.

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.