default databases available in sql server and there uses ?
- 4 Answers
- 5948 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 are the types of resultset?
What is an execution plan?
What is cube dimension? : sql server analysis services, ssas
Can a trigger be created on a view?
How to manipulate data from one table to another table ?
What are the differences between sql server and mysql.
What is Extended user-defined?
How to Check if table exists in sql server?
What is the difference between count and distinct count?
Explain what you mean by 3 tier architecture.
What is the difference between implicit and explicit transaction?
How to handle error or exception in sql?
List types of tables in SQL Azure?
How to configure and test odbc dsn settings?
Difference between drill down and drill through report.
