Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 6930 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / selvam
There are 5 default DB's in Sql server
1. Master - Contains all of the system level information
2. Model- Used as a template db for all db instances created in SQL Server
3. Msdb -- It used by sql server agent, Mail Service
4. Tempdb -- Contains temporary objects and intermediate results
5. Resource -- it is read only db that contains system objects that are included with sql server
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you understand by the analysis services in sql server?
Explain tables in SQL Azure?
What type of locking occurs during the snapshot generation? : sql server replication
what are user defined datatypes and when you should go for them? : Sql server database administration
What do you mean by data integrity?
What is PROJECTION Operation?
Define magic tables in sql server?
What are sql server procedures?
Can you pass expressions to function parameters?
How can we migrate from SQL server to SQL Azure?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What command would you use to add a column to a table in sql server?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Explain filtered indexes benefits?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
