Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 6925 Views
- TCS, I also Faced
- E-Mail Answers
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 sparse columns of sql server 2008?
Do you know how to make remote connection in database?
Explain what is analysis service repository?
What are the diifferences between the ms sql server vs mysql?
Explain hostprotectionattribute in sql server 2005?
What are trace flags and mention a few common trace flags used with sql server?
What is data block and how to define data block size?
What is trigger explain with program?
What is the difference between NOROW and LOCKROW?
What is the process of normalization?
How to get a list of columns in a view using the "sp_help" stored procedure?
Which are new data types introduced in sql server 2008?
In how many ways you can invoke ssrs reports?
Why do we use trigger?
What is sql server used for?
