Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 7283 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
How to verify a login name with sqlcmd tool?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How to update a field in SQL after ALTERING a row?
What is Cross Join and in which scenario do we use Cross Join?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is a cursor, index in sql?
What are the different ways you can create databases in sql server?
What are commit and rollback in sql?
what is an index? : Sql server database administration
Explain Geography datatype in SQL Server
What is database architecture? : SQL Server Architecture
What is 4nf in normalization form?
Where do we use trace frag?
Do I need a report server to run reports in my application?
Can we use max in where clause?
