Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 6972 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / selvam
There are 5 default DB's in Sql server
1. Master - Contains all of the system level information
2. Model- Used as a template db for all db instances created in SQL Server
3. Msdb -- It used by sql server agent, Mail Service
4. Tempdb -- Contains temporary objects and intermediate results
5. Resource -- it is read only db that contains system objects that are included with sql server
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is use of @@ spid in sql server?
Can we use pragma autonomous_transaction in trigger?
How do I determine how many instances of sql server are installed on a computer?
How do I create an extended event in sql server?
What is optimization and its types?
How is foreign key related to primary key?
What to check if a User database is locked?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
How to convert a table data in XML format in sql server?
SQL Server Architecture ?
What is exporting and importing utility?
What is a result set object returned by mssql_query()?
What is difference between Datepart() and Datename() in SqlServer?
Differentiate between SQL and ORACLE joins and write their syntax.
What is user-defined inline table-valued function?
