Answer Posted / varinder sandhu

Dear All,

normally sql sever 2000 supports 16 instance,
this is right.

in 2005 max number is not 50

because sql server 2008 R2 Datacenter supports 25 instance only

i don't think previous version sql server mean 2005 support
50 new 2008 R2 support only 25

it does not make sense.

Ref Article :
http://www.microsoft.com/sqlserver/2008/en/us/R2-editions.aspx

Thanks,
http://varindersandhus.blogspot.com/

How can we get count of the number of records in a table?

957

---

Explain the concept of view and Types of views in SQL server?

995

---

What is sql server agent and what are the two modes of authentication in sql server?

1061

---

Can you explain what are various ways to enhance the ssrs report?

1004

---

How do I find the sql server database version?

1015

---

What is a filestream?

996

---

What is a livelock?

973

---

What is the difference between resultset and resultsetmetadata?

981

---

How the authentication mode can be changed?

1137

---

What are the hotfixes and patches in sql server?

1018

---

What is difference between createstatement and preparedstatement?

1104

---

Explain SSRS Architecture?

199

---

Explain primary key?

974

---

What is the main purpose of having conversation group?

900

---

How is foreign key related to primary key?

972

---