Script to list out important properties of database
Posted by Jugal Shah on November 24, 2009
Use below script to list out the important properties of the database
select
sysDB.database_id,
sysDB.Name as 'Database Name',
syslogin.Name as 'DB Owner',
sysDB.state_desc,
sysDB.recovery_model_desc,
sysDB.collation_name,
sysDB.user_access_desc,
sysDB.compatibility_level,
sysDB.is_read_only,
sysDB.is_auto_close_on,
sysDB.is_auto_shrink_on,
sysDB.is_auto_create_stats_on,
sysDB.is_auto_update_stats_on,
sysDB.is_fulltext_enabled,
sysDB.is_trustworthy_on
from sys.databases sysDB
INNER JOIN sys.syslogins syslogin ON sysDB.owner_sid = syslogin.sid
Daphne Ray said
Hi,
I learn from your website that your company offers databases related solutions and services.
Would you like to take a look at companies who has installed particular database application such as MySQL, Microsoft SQL, Oracle DB 9i, Sybase etc. ?
If yes, we maintain information related to these specific application users and you can use this for your new business generations purposes.
I you are looking to know more more, please reply back with your current target requirement and I will get in touch with you.
Regards,
Daphne Ray
Market Advisor
H.L, Inc
“If you don’t wish to receive our newsletters, reply back with LEAVE OUT in the subject line”