Answer / vani

MSDE: (Microsoft Desktop engine) sql server Express Edition
is the next version of MSDE.

Answer / koti

When Microsoft first introduced MSDE 1.0, it was called
Microsoft Data Engine and it shared the same code base as
SQL Server 7.0. With the release of SQL Server 2000,
Microsoft introduced MSDE 2000 and called it Microsoft SQL
Server 2000 Desktop Engine. This article provides
information on MSDE 2000 as it compares to SQL Server.

How to recreate an existing index in ms sql server?

0 Answers  

---

What is store procedure? How do they work? When do you use?

0 Answers  

---

Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  

---

What are the components of sql server service broker?

0 Answers  

---

Do you know the isolation level that sql server support?

0 Answers  

---

---

How do I save a stored procedure in sql server?

0 Answers  

---

Explain about nested stored procedure?

0 Answers  

---

What is a view?

6 Answers  

---

How to loop through returning rows?

0 Answers  

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

Explain the functionalities that views support?

0 Answers  

---

What is clustered vs nonclustered index?

0 Answers  

---