CATEGORIES
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.
Most Popular Articles
- SQL Server 2008 Error: is not a valid login or you do not have permission
- Cannot start .aspx
- what is the difference between Text and String Data type in SQL Server
- Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
- Why my MS SQL Server 2005 DSN Connection is not Working
Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' >>
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.