What is the basic functions for master, msdb, tempdb databases?

Answer Posted / pinak

the basics function of master is "it stores all sytem level
information in it, all databases which need for user
defineed database.
msdb is microsoft database.it works just like a recorder.

tempdb is a temprary database.

Is This Answer Correct ?    8 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

752


What are the components of dbms?

732


Difference between Logical Page and Physical Page in SSRS.

414


What are the basic functions for master, msdb, model, tempdb databases?

804


What is difference between after and before?

708


What is sql server profiler trace data file?

806


whats the maximum size of view state??

1920


How can i Relate Tables in SSIS

832


Explain intellisense for query editing

779


What will be the maximum number of indexes per table?

729


What is star, snowflake and star flake schema? : sql server analysis services, ssas

876


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

773


What is cross join in sql server joins?

822


How to use "begin ... End" statement structures in ms sql server?

708


What is the return type of executeupdate ()?

708