Setting SQL Server 2005 apart from SQL Server 2000

Asked By mbiloli 0 points N/A Posted on - 10/01/2011

Over the years Microsoft has improved the Microsoft SQL Server originally sold to them by Sybase. Though Sybase has remained in the market renaming it's product to Adaptive server Enterprise. The Microsoft SQL server has continuously been improved. What sets the SQL server 2005 from the previous 2000 model?

• Status: Open
• Question Views: 764
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Exchange Server

Answered By Alber grower 0 points N/A #84753

Setting SQL Server 2005 apart from SQL Server 2000

There are so many difference with the SQL Server. Obviously, the 2005 version has more available functions than the 2000 version. There are so many functions and its hard to enter all of the functions here. Also, the 2005 version works well with the Visual Studio programs and Visual Basic .Net programs.

The 2000 use DTS but the 2005 version uses SSIS (a more advance and much improved version of the DTS) The users of the programs has more options to choose from and can vary on what you set to them. But its ODBC and connection to MySQL is quite failure and needs to be improved.

About Alber grower

Questions
0

Answers
370

Best Answers
106

• Vote Up 0 Vote Down

• Posted on - 10/03/2011
• Question Category: Exchange Server