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:

dboption

kick it on DotNetKicks.com

Advertisements
No comments yet

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

You are commenting using your Google+ 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: