Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

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

0 Answers  

---

Is resultset an interface?

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

What are the advantages of having an index on the sql server?

0 Answers  

---

Explain the etl (extraction, transformation, and loading)?

0 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

What are views used for?

0 Answers  

---

What is exporting utility?

0 Answers  

---

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

---

hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  

---