Checking SQL Server Database Option Settings: Quickie Again
Suppose you “inherited” databases and you want to just quickly go over the databases’ properties. This one particular database caught your attention. This database is a backend of the biggest and busiest system in your company. You are intrigued in what are the options set for this particular database.
Yes, there’s a quickie for that.
EXEC sp_dboption TestDB
You can see it here in action: