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 edit table in sql server 2017?
Difference between server.transfer and server.execute method?
Can we create a clustered index on composite primary key.
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How do you know if sql server is running on your local system?
What are the differences between sql server and mysql.
What is difference between restoration and recovery in SQLServer?
What are extended events in sql server?
What does dml stand for?
What is bit data type?
How to find the service pack installed? : sql server database administration
A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?