default databases available in sql server and there uses ?
- 4 Answers
- 5695 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
Is it possible to replicate data from sql server to oracle? : sql server replication
Explain what is it unwise to create wide clustered index keys?
Define constraints and give an example of their use?
How to create a Master database in SQL server ?
What is the library index called?
Explain hostprotectionattribute in sql server 2005?
Does sql server 2016 have ssms?
What does Master database contains?
Show Practically Sql Server Views are updatable?
What is set nocount on and what is set nocount off?
How will you find out if there are expensive SQL statements running or not?
What is meant by datasource?
Does view occupy space?
What is the difference between osql and query analyzer?
How to use subqueries with the in operators in ms sql server?
