MSSQL Configuring the Database

Most database options can be set in Management Studio within the Database Properties page, which you can access by right-clicking a database in the console tree and choosing Properties from the context menu. The database configuration options can be set using T-SQL ALTER DATABASE SET options as: ALTER DATABASE AdventureWorks2008 SET SINGLE_USER; To view database configuration options using the sys.databases catalog view or the DATABASEPROPERTYEX() function. The following example returns all the database properties of the AdventureWorks2008R2 database: SELECT * FROM sys.databases WHERE name = ‘AdventureWorks2008R2’.

Leave a Reply

Your email address will not be published. Required fields are marked *