What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

How to set a database state to offline in ms sql server?

0 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

What is default port number for sql server 2000?

0 Answers  

---

What is shared lock?

0 Answers  

---

When do you think a developer should use sql server-based cursors?

0 Answers  

---

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

---

What are the difference between primary keys and foreign keys?

0 Answers  

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

0 Answers  

---

How make remote connection in database?

1 Answers  

---

How do I open port 1433?

0 Answers  

---

After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,

---