default databases available in sql server and there uses ?
- 4 Answers
- 6363 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sreeja.t.pillai
Default databases in SQL server are
1.Master
2.Model
3.tempdb
4.msbd
Master-Contains information about all databases and contains system objects.
Model-It is a template database used in creation of any new database.
msdb-It contains information about sql agent,job,dts packaging and some replication information.
tempdb-contains temporary stored procedures and tables.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is a trigger what are the advantages of trigger?
What is plan freezing?
What are the instances when triggers are appropriate?
How do I find my localdb version?
Can we create clustered index on composite key?
What is the use of set nocount on/off statement?
What is the difference between count and distinct count?
What is transaction server isolation?
What is the difference between varchar and varchar types?
What is scheduled job and how to create it?
Explain how does the report manager work in ssrs?
What are cursors in ms sql server?
Ms sql server index?
What is check constraint in sql server?
If a table does not have a unique index, can a cursor be opened on it?
