I have been working a lot with SQL 2005 recently. I have to say that it is a fantastic upgrade from 2000. However, there are a lot of areas of improvement. Some of which are related to management and updates. Overall, it is a great upgrade. the tools are good, the reporting is awesome, the management is very gui and easy to use. The down side is some simple tasks are more difficult. An example is to export a table, you cannot just right click on the table and do tasks -> export / import, you have to do it at the root of the db. Also, when selecting items – dts or jobs, you cannot do a select all you have to select each one.
These are probably items that will be addressed in the new Service Pack.
One interesting item that I just used was to find the version you have installed. YOu can run this script on all versions of SQL 2000/2005 to let you know what version you have.
SELECT @@VERSION
GO
Here are the results
—————————————————————————————————————————————————————————————————————————————————————-
Microsoft SQL Server 2005 – 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
(1 row(s) affected)
