Note: Some features of SQL Server 2000 require more than Microsoft Windows Server version to run. So you install Windows Server 2000 (recommended for advanced version), you can learn and use more features to SQL Server 2000, and enjoy better performance.
This article describes the process of installing SQL Server 2000
Determine which SQL Server Database components version is installed
Use isql, osql, or Query Analyzer to execute one of the following queries against the database engine instance.
SELECT serverproperty (' ProductLevel ')
SELECT @ @VERSION
SELECT serverproperty (' ProductVersion ')
Use the table below to determine your version of Database components.
SQL Server 2000 version and level/@ @VERSION/product level
SQL Server
The primary purpose of monitoring the performance of ISA Server is to enable managers to get relevant alerts in a timely manner to view and address problems when the server is in an unusual situation.
Open the ISA Management Console, expand the Monitoring Configuration node, and click the Alerts folder to list all alerts in the details pane on the right (see Figure 1).
By default, ISA server automatically enables 39 of the 45 alerts. Each alert specifies an event, and the event is reported t
Before configuring SQL Server 2000 database security, you must configure the operating system security to ensure that the operating system is in a safe state. Then, perform necessary security audits on the database software (programs) to be used, such as scripts such as ASP and PHP, which are common security risks for many database-based Web applications, the script is mainly a filtering problem. It is necessary to filter characters such as ",; @/" to
In actual work, especially on servers, it is usually 7 × 24 hours. For this reason, many system programs have the function of restarting the server after the server crashes, that is, the Watchdog function ). For example, if an unattended DVR (Digital Video Recorder Digital Hard Drive Video Recorder) is abnormal, the Reset is automatically restarted ). However, if the system uses the Windows 2000 Server platform, it is critical to automatically log on
Beans need to dispose of an old Windows 2000 Server, but there are programs and databases running on it. After migrating the database because some copyright issues do not work properly, can not, only the entire package P2V.Here are a few prerequisites to complete1. Directly with the latest version of the VMware Converter 6 is unable to convert Windows 2000, because the goods are too old, the last supported
This section describes ten things you can do to improve the security of SQL Server installation:
Install the latest service package
To improve Server security, the most effective method is to upgrade to SQL Server 2000 Service Pack 4 (SP4 ). In addition, you should install all released security updates.
Use the Microsoft Baseline Security Analyzer (MBSA) to evaluate server security.
MBSA is a tool that scans insecure configurations of multiple Microso
occur. You do not need to change the logical file name. It turns out to be a path error.Another Error solution may be used later.How to change the owner of the User table of SQL server 2000 to dbo instead of the user name?Method 1: Right-click the table and choose design table from the shortcut menu. In the previous small icon, click the last "condition constraint" and click the "table" page to change the owner.Method 2: Execute the script directly,
Q: We have more than 50 machines and only one machine is installed on Windows 98. When this machine accesses the Windows 2000 server, it prompts you to enter the password, while other machines can access the server smoothly. What is the reason?A: This may be because another computer has an account with Windows 2000 system access permission, while Windows 98 is not authorized to access Windows
I. Solutions to SQL Server 2000 Installation File suspension errors
This problem occurs when you are installing Microsoft SQL Server 2000:PreviousProgramTo install a file that has been suspended on the installation computer, you must restart the computer before running the installation program.However, after searching for half a day, I did not find any program, and I had to restart the Windows system. I h
Exploring the internal data structure of Windows NT/2000
WebSphere (tsu00@263.net)
Note: This article was initially found at www.nsfocus.com
Windows system implies a lot of internal data structures, which record all important information related to the system, such as threads, processes, and kernel calls, for example, ntbuildnumber and keservicedescriptortable in Windows NT/200020.ntoskrnl.exe (you can see Dependency Walker in SoftICE or Visual Studi
Windows 2000 contains many security functions and options. If you configure them properly, windows will be a safe operating system.========================================================== ========================================================== =====Elementary Security******************
1. Physical Security
The server should be placed in an isolated room with the monitor installed, and the monitor should keep camera records for more than 15 da
Test condition: one public IP address and two static IP addresses.
Procedure:
I. Can I ping the Server IP address?
Check whether the physical connection of the Remote SQL Server 2000 Server exists. If not, check and view the configuration. Make sure that the IP address of the Remote SQL server 2000 server is correctly spelled.
2. Enter the telnet server IP port in Dos or command line to check wheth
security configuration of the SQL Server2000 Database and some related security and usage issues. Before configuring SQL Server 2000 database security, you must configure the operating system security to ensure that your operating system is in a safe state. Then, perform necessary security audits on the database software (programs) You want to use, such as ASP and PHP scripts. This is a common security risk for many database-based WEB applications, t
I have asked the experts in the group. After I have explained my questions over and over again, I still cannot access SQL Server 2000 in my java code.
Fortunately, the world's communication is very developed. During my nearly two days of Baidu (I just started to learn Java), my problem was finally solved by myself.
First, I tried to use jtds. jar as the driver to access SQL Server 2000.
In this way, note th
Write a file in WindowsProgramA process fork generates about 2000 threads and then exits abnormally. Why?
This problem occurs because in Windows 32-bit system, a process can use a maximum of 2 GB of virtual memory, and the default thread stack stacksize of a thread is 1024 K (1 m ), in this way, when the number of threads approaches 2000, 2000*1024 K = 2G (appr
Steps:
Check whether the IP address of the ping server can be pinged.
This is to see whether the physical connection to the remote SQL Server 2000 Server exists. If not, check the network and check the configuration. Make sure that the IP address of the Remote SQL Server 2000 Server is correctly spelled.
2. Enter the IP port of the Telnet server in DOS or command line to check whether the port can be connec
Introduce some common setup methods for setting up security policies for Windows 2000 systems to play a security role.
First, security policy
It is well known that the Windows 2000 system itself has many security vulnerabilities. Patching is a way to reduce most vulnerabilities, but it does not eliminate small vulnerabilities, which are often important ways to attack or invade. The "Local security p
Before you create a SQL Server 2000 failover cluster, you must configure Microsoft Cluster Service (MSCS) and use the Cluster Administrator in Microsoft Windows NT4.0 or Windows 2000 to create at least one cluster disk resource. Before running SQL Server Setup, note the location of the cluster drive in the Cluster Administrator because this information is required to create a new failover cluster. Only SQL
Data | database | Index
SQL Sever 2000 system database and index
Learning Person: hsly
Learning Books: Getting Started with SQL Server 2000 and improving writing date: 2004-7-12
Chapters: 4.1 P44 9.6.1p126
SQL Server 2000 during the installation process, 4 system databases were created, the 4 system databases are the basis for running
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.