Skip to content

Checking SQL Server Database Option Settings: Quickie Again

May 3, 2009

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:


kick it on

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

  • Archives

  • RSS SQLServerPedia

  • RSS SQL Crunch – Hot SQL Links

  • My Bookmarks

  • Business Career DBA Tool Events free ebook Humor IT News Members Only Microsoft MySQL Operating System Oracle Personal Reporting Services SQL Server SQLServerPedia Syndication SSC SSIS TSQL Tutorial Uncategorized Video

  • Software Blogs - BlogCatalog Blog Directory
  • %d bloggers like this: