default databases available in sql server and there uses ?

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


Please Help Members By Posting Answers For Below Questions

How do I find sql server instance name?

724


What is a covered index?

727


Explain how many types of relationship?

783


What is database replication?

794


what is the system function to get current user's user id? : Sql server database administration

757


What are the different types of triggers in SQL SERVER?

759


Explain tables in SQL Azure?

114


Can you explain what is indexed view? How to create it?

729


What is the difference between the application object and session object?

830


Would you store your query in a ssrs report or a database server? State the reason why?

132


What do you understand by the denormalisation?

737


What is transaction server isolation?

773


what are the disadvantages of cursors? : Sql server database administration

725


What is a mutating table error and how can you get around it?

737


Why do we use sql limitations? Which constraints can we use while making a database in sql?

778