Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 7288 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 are the types of lock supported by ?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Differentiate between truncate vs delete in mssql?
Explain indexing and what are the advantages of it?
What does it mean to normalize data?
How to backup SQL Server Reporting Services ?
What is coalesce in sql server?
Can you name some of the dml commands in sql?
What is the purpose of grouping data in a report?
What are the advantages of using cte?
Where to find ntwdblib.dll version 2000.80.194.0?
What is the purpose of self join?
Why we use functions in sql server?
What are different types of data sources?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
