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
How do I find sql server instance name?
What is a covered index?
Explain how many types of relationship?
What is database replication?
what is the system function to get current user's user id? : Sql server database administration
What are the different types of triggers in SQL SERVER?
Explain tables in SQL Azure?
Can you explain what is indexed view? How to create it?
What is the difference between the application object and session object?
Would you store your query in a ssrs report or a database server? State the reason why?
What do you understand by the denormalisation?
What is transaction server isolation?
what are the disadvantages of cursors? : Sql server database administration
What is a mutating table error and how can you get around it?
Why do we use sql limitations? Which constraints can we use while making a database in sql?