Answer / srinivasa ganamur

Hi,

In 2000 : Log Shipping require Enterprise Edition.Expensive
hardware.

In 2005 : Log Shipping available in Standard Edition.cheap
hardware.

Regard's
Srinivasa Ganamur

Answer / patel

Log shipping is not depending on any hardware.

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

0 Answers  

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

How is sql server used?

0 Answers  

---

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

Define magic tables in sql server?

0 Answers  

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

What is replication and database mirroring?

0 Answers  

---

How to create a large table with random data for index testing in ms sql server?

0 Answers  

---