Home > Article > Backend Development > 13 Examples of Answers to SQL SERVER Application Questions (1)_PHP Tutorial
13 Examples of Answers to SQL SERVER Application Questions (1)_PHP Tutorial
- WBOYOriginal
- 2016-07-13 17:00:43820browse
Question: How to operate SQL Server 6.0 server under SQL Enterprise Manager version 6.5?
Answer: Before using SQL Enterprise Manager version 6.5 to operate SQL Server 6.0, you must first run
SQLOLE65.SQL on the 6.0 server. The file is in the directory of MSSQLINSTALL.
Question: Before upgrading SQL Server 6.0 to SQL Server 6.5, why do you need to execute the Chkupg65.exe utility first?
Answer: Chkupg65.exe will automatically detect whether the SQL Server 6.0 database is in a normal state and whether each object in the database uses the new keywords in SQL
Server 6.5. And record the detected error information to the output file with OUT as the suffix.
Question: How to move a database file from one disk to another disk in SQL Servr7.0?
Answer: You can use the SP_DETACH_DB and SP_ATTACH_DB system stored procedures to achieve this. The steps are as follows:
Run SP_DETACH_DB to separate the destination database from SQL Server.
Copy the data files (.MDF) and log files (.LDF) of the destination database to the destination disk.
Run SP_ATTACH_DB to restore the files on the destination disk to SQL Server.
Question: How to modify the Character Set of SQL Server7.0 database?
Answer: Use rebuildm.exe to modify Character Set and Sort Order. Modifying the Character Set will affect all data
libraries managed by SQL Server, that is, all databases will use the new Character Set.
Question: How to upgrade from SQL Server6.5 to SQL Server7.0 on two machines?
Answer: First, set the running account of SQL Server 6.5 to a domain account, and SQL Server 7.0 installed on another machine also uses this domain account
. Secondly, this domain account must belong to the administrator group of these two machines. Finally, the machines running SQL Server6.5 and SQL Server7.0 must be in the same domain.