default databases available in sql server and there uses ?
Answers were Sorted based on User's Feedback
Answer / rajesh bhawsar
1.Model
Model database is templete. when u create new database
system gives u a copy of model database
2.Tempdb
Tempdb is scratchpad of sql server
3.msdb
4.master
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / 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 |
How to get max 100 values from sql server
How do we know if any query is retrieving a large amount of data or very little data?
What do you understand by user-defined function in the sql server?
What are the tool windows in sql server management studio? : sql server management studio
What is the difference between for xml raw and for xml auto?
What is clustered vs nonclustered index?
What is multilevel indexing?
What factors you will consider calculating the storage requirement for that view?
Why is DML provided?
1 Answers Ernst Young, Thomson Reuters,
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What are the instances when triggers are appropriate?
How to enter date and time literals in ms sql server?