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 |
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What are the parts of a function?
How much space does sql server 2016 take?
What is difference between Datepart() and Datename() in SqlServer?
What is bit data type? What's the information that can be stored inside a bit column?
What is normalization of database? What are its benefits?
What is stored procedures?
What is the maximum row of a size?
What is the default port for SQL Server over a firewall?
define and explain the differences between clustered and non-clustered indexes.
what is Equity join?
how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?