SQL Server Performance Forum – Threads Archive
How to check these settings of a DBAnyone have any idea how to check following settings are enabled for a Database 1)Checksums (Checksums belong to a class of hashing algorithms designed to detect errors or changes to data (e.g. Tripwire).)
2)Hash Totals (A hash total is a unique number generated by a one-way hash function that no two files share.)
3)Hashed Message Authentication
5)Data Edit Routines
7)No data reconciliation routines are used to protect the integrity of e-PHI.
1) sp_table_validation 4) Select rows from sysindexes or select count(*) from tablename
5)…. SP_CONFIGURE is server wide and DATABASEPROPERTY are the named database property. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
my client want to knwo these options are enabled in a DB or not.yes other than 1,4,5 all are network related configurations. 1) sp_table_validation – with this hw can i check if checksum is enabled or not.
4) Select rows from sysindexes or select count(*) from tablename
its givin a no of records with different rows value.
wht is this?
5)…. SP_CONFIGURE is server wide and DATABASEPROPERTY are the named database property.
withthis hw i check Data Edit Routines is enabled or not.
Can u please brief these little more? By default al these are enabled only no? then i can send mail sayin its al enabled. please advice and tel me whts it exacly
Please ignore my message. Client reported it was somthing to do from appli side.anyway i need to do some R&D in checksum and all. anwyay Sathya, thanks a lot. Rajiv