Shulou(Shulou.com)05/31 Report--

This article mainly introduces the solution of "device activation error" prompted by SQL Server 2000. In daily operation, I believe that many people have doubts about the solution of "device activation error" prompted by SQL Server 2000. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "SQL Server 2000 prompt" device activation error solution. Next, please follow the editor to study!

Solution 1: right-click the table-"Design Table, in the row of small icons above, click the last" conditional constraints ", click" Table "page, and change the owner inside.

Solution 2: use the script to execute directly, log in to the database with the system account or overaccount, and then execute the following statement: (note: the second method can only be used once, the second use will make an error)

Solution 3: I believe that many friends have a big head when they encounter this problem, and then the solutions they get when searching for similar problems on the Internet are basically the same. the result is the same. Even if I can't solve the problem, I am a few days older. After installing and uninstalling N times, there is no solution to the problem. I continue to explore in the hesitation of version differentiation and inconsistent database structure. Later, a solution was found in an inadvertent restore of the database, as follows (only with my problem solution, other types can be borrowed):

Preparation: SQL server 2000 files that have been backed up, with a suffix added to the file name (.bak, sql server 2000 backups are usually suffixed like this)

Sql server 2000 already installed

Restore the database process:

First, open the Enterprise Manager, find the database option, and create a new database (testdata)

Second, right-click the newly created database (testdata), select "all tasks"-> "restore Database". Select "from device" in the pop-up dialog box, and click "Select device" to find the previously backed up data.

After successive "OK", the dialog box shown here appears:

Third, click again: "options"

In the dialog box that appears, first select "Force restore on the existing database". The most important content is as follows: don't worry about the two files under the logical file name, just look at the following "move to the physical file name". Those two options must select the installation directory of sql server 2000. I made an error because I set its directory to disk d (disk D is where I installed the management directory. That is, the "physical file name" must be the same as the SQL server2000 installation directory.

At this point, on the "SQL Server 2000 prompt" device activation error "solution" study is over, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.