Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 7094 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
Explain tables in SQL Azure?
How you can change a cross join into an inner join?
what is the difference between a primary key and a unique key? : Sql server database administration
List some case manipulation functions in sql?
Write a SQL query in order to merge two different columns into single column?
What is Sqlpaging in SqlServer 2005 ?
Can we perform backup restore operation on tempdb?
Are semicolons required at the end of sql statements in sql server 2005?
Explain the steps needed to create a scheduled job?
Is port 1433 secure?
When would you prefer to have a minimum number of indexes?
What is the difference between truncate and delete commands?
What are page splits?
Explain the difference between function and stored procedure?
Distinguish between commit and rollback?
