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
What is the difference between Stored Procedures and triggers?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is difference between rownum and rowid?
Differentiate between sql temp table vs table variable?
What is the difference between a primary key and a unique key? Are they the same?
What do you mean by SQL injection attack?
What are the purposes of floor and sign functions?
What is an index in sql?
Where sql server usernames and passwords are stored in a sql server?
Is sql different from sql server?
how to use DTS package in 2000,2005,2008 in sql server
what are different types of raid configurations? : Sql server database administration
How to disable triggers using "disable trigger"?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is usually the first word in a sql query?