default databases available in sql server and there uses ?
- 4 Answers
- 5687 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
Tell me about builtinadministrator?
What are types of storage modes? : sql server analysis services, ssas
What purpose does the model database server?
How to create hyperlink from returned sql query ?
What is an index in sql?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Can two tables have the same primary key?
What is order of B+tree?
What is user defined stored procedures?
What are the differences between web role and worker role?
What is openrowset sql server?
What is entity data services?
Explain table valued parameters in sql server? Why tvp used?
Why would you use sql agent?
How can you start sql server in different modes?
