Protect your SQL Server database from unauthorized access, modification and distribution! Hides schema!
 
About DBDefence
System Requirements
Installation
Configuration and Startup
DBDefence Configurator
Starting DBDefence
Database Encryption
Introduction
Hardware Encryption
Encryption Tools
Encryption API
Exceptions
Database decryption
FIPS 140-2 Information
Database Access
Introduction
Using SQL commands
DBDefence Client DLL
Reporting Services Extension
Editing Database with SQL Studio
Service Broker Access
Hiding DbDefence
Hiding DbDefence
Profiler Protection
Profiler Protection
Backup, Distribution ...
Replication
Backup
Distribution
DBDefence SQL functions
dbd_hardware_aes
dbd_listdb
dbb_on
dbd_reg_info
dbd_status
Sales questions
Purchase and support
Activation
Acknoledgements
DBDefence 2.10 Reference

dbd_listdb

exec master..dbd_listdb

Function lists encrypted database names and its access status.

This function is not needed for core functionality of DbDefence however Client DLL rely on that feature to define if DbDefence is installed on that server and if there are any encrypted databases. If this function do not list any databases Client DLL do not display its dialog.

 

Note: On SQL Server Express databases has default option called AUTO_CLOSE ON. This feature is always ON when you attach or create database. If it is ON then SQL Server unloads unused database from memory. This behavior may lead to confusion. dbd_listdb will not display unloaded database and Client DLL will not display login dialog as expected.

To solve the problem set AUTO_CLOSE OFF for encrypted database as:

ALTER DATABASE DbName SET  AUTO_CLOSE OFF

You need to do it every time where database attached to server. You can see current AUTO_CLOSE state for databases with the command: select name,is_auto_close from sys.databases

By default this option is OFF on SQL Server editions other than Express.


support@dbdefence.com
Copyright Elitude Software, 2009-2011