SQL Server application Problem answer 13 cases 1

Server| Solution | Question: How do I operate a SQL Server 6.0 server under SQL Enterprise Manager version 6.5?


A: Before you operate SQL Server 6.0 using SQL Enterprise Manager version 6.5来, you first run under 6.0 of the server
SQLOLE65. SQL, the file is in the Mssql\Install directory.


Q: Before you upgrade SQL Server 6.0 to SQL Server 6.5, why do you want to execute the Chkupg65.exe utility first?


A: Chkupg65.exe automatically detects whether the SQL Server 6.0 database is in a normal state, and whether the individual objects in the database use SQL
The New keyword in Server 6.5. The detected error message is logged to the output file with the out suffix.


Q: How do you move a database file from one disk to another in SQL Servr7.0?


A: You can use the sp_detach_db and sp_attach_db system stored procedures to implement. The steps are as follows:


Run sp_detach_db separates the destination database from SQL Server.


The data file for the destination database (. MDF) and log files (. LDF) Copy to the destination disk.


Run sp_attach_db to restore the files on the destination disk to SQL Server.


Q: How do I modify the character Set of the SQL Server7.0 database?


A: Use Rebuildm.exe to modify the character set and sort order. Modifying character set affects all data managed by SQL Server
Library, that is, all databases will use the new character Set.


Q: How do I upgrade from SQL Server6.5 to SQL Server7.0 on two machines?


A: First, you set the SQL Server6.5 run account to a domain account, and the SQL Server7.0 installed on another machine uses that domain account
Households. Second, this domain account belongs to the Administrators group of both machines. Finally, the machines running SQL Server6.5 and SQL Server7.0 are in the same domain.