RSS feed

what is the difference between SQL server 2000 and SQL Server 2005

Published by: Rinku (9/3/2008 8:15:23 PM)

SEP 3 2008

What is the difference between Microsoft SQL server 2000 and SQL server 2005 from a programmer’s view point apart from the Management studio. What are the major changes and enhancements to T-SQL in SQL server 2005.Please explain.

 

Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' >>

<< Can views be indexed ?

 

COMMENT

Name: Neha Vohra

XML services is provided in 2005 not in 2000

Name: Neha Vohra

In Sql server2000 we can create 65,535 databases,whereas
in Sql server2005 2(pow(20))-1 databases can be created.

*Name:
*Comment:
You can use HTML tags here.
*Code: Please enter the sum of 5+2