SQLServer 2005 first experience

xiaoxiao2021-03-18  182

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 ...

转载请注明原文地址:https://www.9cbs.com/read-129944.html

New Post(0)