Indicates which users can access the database. READ_WRITE = data can be read and modified READ_ONLY = data can be read but not modified RECOVERING = database is recovering and not yet ready for queries
#Full convert enterprise select database Offline#
OFFLINE = database was explicitly taken offline Microsoft® SQL Server™ detects incomplete I/O operations caused by power failures or other system outages. The tables of the database can be published for snapshot or transactional replication, if replication is installed.ĭatabase can be subscribed for publication.
#Full convert enterprise select database update#
For complete lists look here: SQL 2000, SQL 2005.ĭatabase shuts down cleanly and frees resources after the last user exits.Įxisting statistics are automatically updated when the statistics become out-of-date because the data in the tables has changed.ĭatabase files are candidates for automatic periodic shrinking.Īuto update statistics database option is enabled. Some of the things you can find out about your databases include the following information. So to find out the recovery model and status for all databases on my server I can run the following command and the get following results:ĭATABASEPROPERTYEX ( name, 'Recovery' ), This function can be called from a SELECT statement to return the results of one or more databases. SQL Server 20 have a built-in function called DATABASEPROPERTYEX that allows you to return the specific information you are looking for, for one or all databases. And when querying the system tables, you often need to join multiple tables to get the results you need as well as convert the results to make sense of them. With the T-SQL commands such as sp_helpdb the database options are all strung together and not listed out individually. When using the GUI tools you can't easily grab just the information that you need and you can only look at one database at a time. But the way the information is returned may not always be the most useful. By: Greg Robidoux | Updated: | Comments (6) | Related: More > Database Administrationįinding out information about database settings is not that hard when you use Enterprise Manager or Management Studio, T-SQL commands such as sp_helpdb or query the system tables directly.