default databases available in sql server and there uses ?

Answer Posted / rajesh bhawsar

1.Model
Model database is templete. when u create new database
system gives u a copy of model database
2.Tempdb
Tempdb is scratchpad of sql server
3.msdb
4.master

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain optimistic and pessimistic concurrency?

624


What is cursor in ms sql server?

653


What is 'write-ahead log' in sql server 2000 ?

708


Is there any difference between primary key and unique with the not null condition?

608


explain different types of cursors? : Sql server database administration

652






What is the difference between function and stored procedure in sql server?

582


What are the built in functions in sql server?

571


How can I add Reporting Services reports to my application?

97


Define Business Edition in SQL Azure?

94


How to find table changes in sql server?

748


What is self contained multi valued query?

633


What is compression - row-level and page-level compression?

603


What method is used by the Command classes to execute SQL statements that return single values?

670


what are the critical issues you have resloved in your company

1629


What is a trigger and its types?

630