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/

explain different levels of normalization? : Sql server database administration

995

---

How to check if stored procedure is running in sql server?

1045

---

What are the advantages of partitioning?

1098

---

How to enforce security in sql server? : sql server security

1097

---

What is the standby server?

946

---

What is lock escalation? : sql server database administration

1147

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

895

---

What are the differences between stored procedure and the dynamic sql?

1080

---

Can we store videos inside the sql server table?

972

---

Which tcl commands are available on the sql server?

1074

---

What are the advantages of user defined function?

978

---

What are indexes in sql?

1269

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

932

---

What are two difference between sql azure and azure tables?

159

---

What is the maximum size per database for sql server express?

1039

---