Answer Posted / sonia

guess what you want to ask is that what are the databases
that come by default? 4 - Master, Model, msdb, tempdb.

Tell me what is the order in which the sql query is executed?

1014

---

how can a database be repaired? : Sql server administration

1016

---

Do you know what are the reporting services components?

1020

---

How can I create a new template for import ? : sql server management studio

1113

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2138

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1049

---

Describe in brief sql server monitoring ways.

1098

---

What is the use of custom fields in report?

1041

---

Where views are stored in sql server?

1030

---

What is table-valued sub query?

1026

---

How to grant a permission in ms sql server using "grant execute" statements?

1134

---

Explain what are magic tables in sql server?

1046

---

How to view existing indexes on an given table using sys.indexes?

1151

---

Can you import Microsoft Excel data to SSRS?

135

---

What are distinctive joins find as a part of sql?

1000

---