Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 7119 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
How can you insert null values in a column while inserting the data?
Do you know what are the restrictions that views have to follow?
What is the sql profiler?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is the security principal at the database level that represents your session?
How efficient you are in oracle and SQL server?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
What is ms sql server reporting services?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How to test odbc dsn connection settings?
How to drop an existing table with "drop table" statements in ms sql server?
what are different types of raid configurations? : Sql server database administration
What is index fragmentation in ms sql server?
What the difference between UNION and UNIONALL?
what is normalization? Explain different levels of normalization? : Sql server database administration
