Difference between SQL2000 and SQL2005

[divyaswati]

what is the major and minor differences between SQL2000 and SQL2005

divya

[Duncan Edwards Jones]

SQL 2005 has: * CLR integeation * Better XML capabilities * New T-SQL syntax for pivot tables etc. There are pages and pages on MSDN about this if you need more info.

'--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd

[Frank Kerrigan]

Theres is a new Integration Services which replaces DTS. DTS is "legacy" and can't be changed unless you install a downloadable tool.

---

Look where you want to go not where you don't want to crash. Bikers Bible

[Kevin McFarlane]

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx[^]

Kevin