In SQL Server 7.0, why not restart the SQL Server Service to cycle the errorlog (error log )? (New)
In SQL Server 7.0, if cycle errorlog is required (that is, a new errorlog is generated, errorlog is changed to errorlog.1, errorlog.1 to errorlog.2 ,...) however, SQL Server Service is not re-activated. In SQL Server 7.0, a new Stored procedure: sp_cycle_errorlog is provided. You can use this stored procedure to achieve the cycle errorlog function.
Install Internet explorer 5.0 on a Windows 7.0 computer with SQL Server 95/98 installed. When you execute the SQL Server 7.0 Wizard or click the properties page, the following error occurs: "The execution of this job is invalid, close soon. If the problem persists, contact the program designer. "Or other error messages?
This is because the file comctl32.dll is changed when Internet assumer5.0 is installed. Upgrade SQL Server 7.0 to Service Pack 1.
After installing the Office 2000 or Microsoft SQL Server 7.0 client program, the MS Query attached to SQL Server 6.5 is used to access the information of SQL Server 6.5. How can this problem be solved?
This may be because you use the SQL Server ODBC 3.70.06.23 Driver. Do not set "Perform translation for character data" and upgrade SQL Server ODBC to 3.70.06.90. Note: SQL server 7.0 is attached with 3.70.06.23, and SQL server 7.0 SP1 is attached with 3.70.06.90.
How can I query the most complete information about SQL Server 7.0 through the Internet?
Refer to the Microsoft website
Which versions of Microsoft SQL Server 7.0 are available currently?
EnterPrise Edition.
Standard Edition.
Desktop Edition.
Unless otherwise mentioned, Standard Edition (Standard Edition) is generally used ).
Are there any Chinese versions of SQL Server 7.0?
SQL Server 7.0 is a dual-byte version and can be installed on the Chinese version of Windows NT Server4.0.
How to activate MSSQLServer 7.0 desktop edition with the command prompt character?
Run the following command: c: mssqlinnscm.exe-Action 1-Silent 1
Can I activate SQLServerAgent of SQL Server 7.0 Desktop Edition under the command prompt?
No. This is a product restriction.
How to increase the number of SQL Server 7.0 error logs?
The default number of SQL Server instances is six. To increase the number, run the following commands in Query Analyzer:
Xp_regwrite 'hkey _ LOCAL_MACHINE ', 'softwaremicrosoftmssqlservermssqlserver', 'numerrorlogs', 'Reg _ dword', 20
How to reconstruct the Master database of SQL Server 7.0?
SQL Server 7.0 provides a new tool: Rebuildm.exe, which is located in MSSQLBINN. Note that MSDB and MODEL databases are also created when the Master database of SQL Server 7.0 is rebuilt. AREMicrosoftMSSQLServerMSSQLServer ', 'numerrorlogs', 'Reg _ dword', 20
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
