SEO EXPERT MITHILESH

Saturday, December 28, 2013

SQL SERVER 2000 , SQL SERVER 2005, SQL SERVER 2008 Version Differences

1. Query Analyser and Enterprise manager are separate.

2. No XML datatype is used.

3. We can create maximum of 65,535 databases.

4. Nill

5. Nill

6. Nill

7. Nill

8. Nill

9. Nill

10. Nill

11. Nill

12. Nill

13. Can’t compress the tables and indexes.

14. Datetime datatype is used for both date and time.

15. No varchar (max) or varbinary(max) is available.

16. No table datatype is included.

17. No SSIS is included.

18. CMS is not available.

19. PBM is not available.