Answer Posted / 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

Describe in brief databases and sql server databases architecture.

1064

---

Differentiate sql server reporting services vs. Crystal reports?

209

---

What is the Main Difference between ACCESS and SQL SERVER?

1181

---

Can a function call a stored procedure in sql server?

1001

---

What is bcnf normalization form?

1158

---

Can you get second highest salary from the table?

1006

---

How can I check if a view exists in a sql server database?

1079

---

Please explain what is “asynchronous” communication in sql server service broker?

979

---

How many full-text indexes can a table have?

1023

---

What is data mart? : sql server analysis services, ssas

1100

---

How can you list all the table constraints in a database?

980

---

What is pivot and unpivot?

1061

---

Why use stored procedures in sql server?

1057

---

How to enter comments in transact-sql statements?

986

---

Different types of keys in SQL?

1141

---