I installed SQL Server2005 to feel its function. The first feeling is to manage more tools, and I haven't used it yet.
Its business manager is called: SQL Server Management Studio Express
As the interface, like VS2005, some management functions are added. Still study.
The addition and recovery database and SQLServer2000 are similar, try to restore the previous SQL2000 database, but the database in the database is not deleted! (Depressed ...),
I have to add a confidant user.
Pay attention to the options of the column of the above password! Then set up user mapping is OK.
There is also a question is that the view created in SQL2000 can't open, prompt
Do not know what is the reasons of that!!!
It seems that it is really useful, the problem is quite a lot ...