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,

---

What is log shipping?

0 Answers  

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

How to create a store procedure with encryption?

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

---

What is the difference function and stored procedure?

0 Answers  

---

Why would you use sql agent?

0 Answers  

---

Does sql server 2000 full-text search support clustering?

0 Answers  

---

Is it ok to shrink transaction log?

0 Answers  

---

Do you know the cursor optimization tips?

0 Answers  

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---