default databases available in sql server and there uses ?
- 4 Answers
- 5669 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 server-level principal?
Can foreign key be duplicate?
explain different types of constraints? : Sql server database administration
What are transactions in sql?
Explain about remote stored procedure?
How to check status of stored procedure in sql server?
What is precedence constraint?
How will you decide the active and passive nodes?
What is the difference between Triggers and Stored Procedure?
What is sql server 2000 work load governor?
What are the different normalization forms?
Which table keeps the locking information?
What are the different index configurations a table can have?
What are the functions in sql server?
How many triggers you can have on a table?
