What is the difference between insensitive and scroll cursor?

0 Answers  

---

How to provide login information for a new odbc dsn?

0 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

What are Magic Table?

34 Answers   3i Infotech, Digiweb, Evalueserve, NIIT, PL,

---

List some case manipulation functions in sql?

0 Answers  

---

default databases available in sql server and there uses ?

4 Answers   TCS,

---

How to convert numeric expression data types using the cast() function?

0 Answers  

---

What is the most common trace flags used with sql server?

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

---