• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

check PAGE_VERIFY in SQL 2000

how can you find out the PAGE_VERIFY option in SQL 2000, for a database? (CHECKSUM / TORN_PAGE_DETECTION)

Thanks
0
anushahanna
Asked:
anushahanna
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I found this:
http://connect.microsoft.com/SQLServer/feedback/details/125074/verify-page-checksum-option-not-reported-in-sp-helpdb-or-databasepropertyex
>VERIFY_PAGE CHECKSUM option not reported in sp_helpdb or DATABASEPROPERTYEX()<

Hi Linchi, This is BY DESIGN. Neither databasepropertyex() nor sp_helpdb() were enhanced beyond their SQL 2000 functionality, which included new database options. You should use sys.databases for accessing the new options as well as the old. Thank you.


in other words: it's not there (at least not in clear values).
possibly the column "status" or "status2" from master.dbo.sysdatabases contains the value as bit ...
0
 
anushahannaAuthor Commented:
OK. Thanks.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now