SQL Server 7.0 General issues

Source: Internet
Author: User
Tags microsoft sql server odbc mssql mssqlserver versions microsoft website
server| problem ""microsoft SQL Server 7.0"hereinafter referred to as"sql server 7.0""

In SQL Server 7.0, how do I cycle errorlog (error log) without restarting the SQL Server service? (NEW)

In SQL Server 7.0, if you want to cycle errorlog, (that is, to recreate a new errorlog,errorlog to errorlog.1,errorlog.1 into errorlog.2, ...) Without reactivating the SQL Server Service, a new stored procedure:sp_cycle_errorlog is provided in SQL Server 7.0. You can use this stored procedure to achieve cycle errorlog functionality.

Installing Internet Explorer 5.0 on a computer that has Windows 95/98 with SQL Server 7.0 installed, often has "invalid execution of this job when executing SQL Server 7.0 Wizard or clicking on the property pages." is about to close. If the problem is not resolved, contact the program designer. "Or what about other error messages?"

This is because the installation of the Internet Explorer5.0 changed the Comctl32.dll file. Please upgrade SQL Server 7.0 to service Pack 1.

After you install the Office 2000 or Microsoft SQL Server 7.0 client program, the data that SQL Server6.5 has attached to access SQL Server 6.5 from MS Query is garbled how do I solve it?

This may be because you are using SQL Server ODBC 3.70.06.23 version of driver. Do not set "perform translation for character data" and upgrade the SQL Server ODBC version 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 Internet for the most complete information about SQL Server 7.0 products?

Refer to the U.S. Microsoft website http://www.microsoft.com/sql/default.asp, you can inquire about the product overview, functionality, system requirements, assessment tools, product prices and other related information

What are the current versions of Microsoft SQL Server 7.0?

EnterPrise Edition.
Standard Edition.
Desktop Edition.
If not specifically mentioned, generally refers to standard Edition (Standard Edition).

Are there any Chinese versions of SQL Server 7.0?

SQL Server 7.0 is a double-byte version that can be installed on the Windows NT Server4.0 Chinese version.

How do I activate MSSQLServer 7.0 Desktop Edition under a command prompt character?

Please execute the following directive: C:\mssql\binn\scm.exe-Action 1-silent 1

Can I activate the SQLServerAgent of SQL Server 7.0 Desktop Edition under command prompt characters?

No way. This is a product restriction.

How do I increase the number of SQL Server 7.0 error logs?

The number of SQL Server presets is six, and if you want to increase, execute the following directives under Query Analyzer:
Xp_regwrite ' HKEY_LOCAL_MACHINE ', ' Software\microsoft\mssqlserver\mssqlserver ', ' numerrorlogs ', ' REG_DWORD ', 20

How do I rebuild the master database for SQL Server 7.0?

SQL Server 7.0 provides a new tool: Rebuildm.exe, this file is located in Mssql\Binn. It is essential to note that the master database that rebuilds SQL Server 7.0 also builds msdb and model databases. Are\microsoft\mssqlserver\mssqlserver ', ' numerrorlogs ', ' REG_DWORD ', 20


Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.