Answer Posted / neel

Establishes the maximum number of SQL Server 2008 instances
that can be created on a server. Enterprise Edition
supports up to 50 instances on a server, Compact Edition
only supports one instance, and all the other editions
support up to 16 instances.

Explain sql server service broker?

956

---

What are the 2 types of classifications of constraints in the sql server?

1100

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

983

---

How do I edit a stored procedure in sql server?

903

---

Explain the Ways to improve the performance of a sql azure database?

82

---

Explain about system stored procedure?

1017

---

What are the restrictions while creating batches in sql server?

1039

---

Why variables called the most powerful component of ssis?

1056

---

What are trace files?

935

---

What are the types of database schema? : sql server analysis services, ssas

1107

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

970

---

Explain the database you used in your final year project?

1018

---

What is user defined datatypes and when you should go for them?

999

---

What is table constraint?

970

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1008

---