Step 1: query using SQL statementsSelect @ versionThe query result is as follows:Microsoft SQL Server 2000-8.00.2039 (Intel x86)May 3 2005 23:18:38Copyright (c) 1988-2003 Microsoft CorporationPersonal Edition on Windows NT 5.1 (build 2600: Service Pack 2)8.00.2039 indicates the version of the installed SQL Server. Find the patch version corresponding to the following table. 8.00.2039 indicates that SP4 is installed, and 8.00.760 indicates that SP3.Ste
install the driver for JSP access to SQL Server 2000:
Step 3: ---- install the JSP driver for accessing SQL Server 2000:
Download the driver from Microsoft's website: the SQL Server 2000 For JDBC driver, which is available on Google.
Then install it. (For example, the installation directory is D: \ SQLDriverForJDBC .)
Three jar files under the lib directory in t
Original article: Inside SQL Server 2000's Memory Management Facilities
Translation: RicCC
Ken HendersonMicrosoft CorporationJanuary 2004This topic is excerpted from Ken Henderson's "The Guru's Guide to SQL Server Architecture and Internals" (Addison-Wesley, 2003 ). License. Copyright.Abstract: Ken Henderson explores SQL Server Memory Management from the developer's perspective.
IntroductionIn this column, we will discuss SQL Server Memory Management
Solution to remotely connect to the SQL Server 2000 Server:
The requirement is as follows: You need to remotely connect to the SQL Server 2000 Server in another region.
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 Ser
This section describes ten things you can do to improve the security of SQL Server installation:
1. Install the latest service package
To improve server security, the most effective method is to upgrade to SQL Server 2000 Service Pack 3A (sp3a ). To download sp3a, visit the SQL Server 2000 sp3a page.
In addition, you should install all released security updates. To subscribe to notifications of new se
A recent project to get some data that exists on other servers is implemented in a way that is pushed by other "servers" to our servers for security reasons. Our server is using SQL Server 2008 R2, other "Servers" are using SQL Server 2000, are running on Windows XP, the whole process encountered some problems, but also refer to some documents, the final cost of a lot of things to be done.
"First, configure the Distributor"
The Replication service f
2.2.3 Install SQL Server 2000
Installing SQL Server 2000 is simpler and the process is similar to other Microsoft Windows products. We have installed SQL Server Standard Edition as an example, the installation process and instructions are as follows:
• Put SQL Server 2000 CD-ROM into the CD drive. If you have the Autorun feature, the installer splash screen will
Server|web| Program | full-Text Search
Build a WEB Search application using Microsoft SQL Server 2000 Full-text search capabilities Andrew B. Cencinimicrosoft Corporation December 2002 applies To: NBSP;NBSP;NBSP;N Bsp Microsoft®sql™server 2000 Summary: Learn how to take advantage of the full text search capabilities of SQL Server 2000. This article contains sever
Windows 2000 systems are so much more user-led to the top of the system, but that's not to say that Windows 2000 is not as safe as it is reasonably configured and well-managed. I use Windows 2000 time is not short, for the maintenance of its security, but also gradually feel a little road, the following is a little personal insights, deficiencies, but also please
New features for 1.2 SQL Server 2000
SQL Server 2000 fully expands the performance reliability and ease of use of SQL Server 7.0 to make it an outstanding database platform for large online transaction processing data warehouses and E-commerce
The new features of SQL Server 2000 are mainly as follows:
1.2.1 Database Enhancements
SQL Server
frontpage| Specification | design | Web page | Web design | style sheet Dreamweaver is expanding to more "net worm" hard drives with its powerful features, yet Dreamweaver is not as good as every feature. At the very least, the style sheet (CSS) settings are too professional, so that these English-poor "bugs" are a big headache. After the n download, installation, in the end I found the best already in their own hands, that is my storage for a long time-FrontPage2000. Below let me lead you to sh
server| data
SQL Server is a relational database management system that was originally developed by Microsoft, Sybase and ashton-tate three companies and launched its first OS/2 version in 1988. Microsoft and Sybase split up on SQL Server development after Windows NT was launched, and Microsoft migrated SQL Server to Windows NT systems to focus on developing Windows NT to promote SQL Server Version, Sybase is more focused on the application of SQL Server to UNIX operating systems.
SQL Server
If you are overly trusting password protection for Access 2000 databases, you may suffer a loss. This is because Access 2000 's database-level password is not secure, but it is fragile, and even the following very small program can break it:
Program One (VB6): Access 2000 Password deciphering
Private Sub Command1_Click ()
Const offset = h43 file offset Address:
When you install Windows 2000, does the user need to make a choice between the FAT32 file system or the NTFS file system? This is actually a very simple question, there is only one reason not to choose the NTFS file system, which is that you also need to use an operating system that cannot read NTFS partitions, such as Win9x, MS-DOS, and so on.
Introduction to NTFS
NTFS is the abbreviation for the new technology file system. Microsoft launched the N
Requirements are as follows: you need to remotely connect to a foreign SQL Server 2000 Server.
Test condition: A public network IP, two static IP.
Specific steps:
A, ping server IP can ping pass
Observe whether the physical connection exists for the remote SQL Server 2000 Server. If not, check the network to see the configuration, and, of course, make sure that the remote SQL Server
1. The website system of the Environment Company uses IIS + Oracle, but a system of the company uses Sqlserver 2000, but the data needs to be made into reports and put on the website. To simplify programming, useOracle is A transparent gateway that regularly captures data from Sqlserver through www.2cto.com A: Web ServerOS: Windows Server 2008IP: 10.108.3.10 install software: IIS, Oracle ClientB: Oralce DB ServerOS: Windows Server 2008IP: 10.108.3.20
Modify SoftIce to prevent it from being detected in 2000/xp
Method from here http://www.woodmann.com/upload/showthread.php? S = threadid = 1806.
Here I want to talk about some of my experience with modification, which is basically the same as the content mentioned in the above post. We only need to add some explanations to avoid SoftIce detection under 2000/xp. We need to modify three files. NTICE. SYS and
Windows XP/2000 enables automatic login:You can change the registry regardless of whether the computer has added a domain.Create several key values in the Registry HKEY_LOCAL_MACHINE/software/Microsoft/Windows NT/current version/Winlogon.Create a two-byte (REG_DWORD) value item AutoAdminLogon. If the value is 1, the automatic logon function is enabled. If the value is 0 or the value does not exist, the automatic logon function is not used.Modify the v
What is data compression?
Here, data compression is the Windows 2000 built-in characteristics on NTFS partition. in theory, compression works by replacing character characters of repeated information with a few characters, and transmitting only one copy of Repeated sequences of data. it is not a tool, such as WinRAR or WinZip, but built-in characteristics on NTFS partition.
Data Compression is used to store files using less disk space, therefore en
used by dbreindex
PointView Source images
Conclusion
Index fragmentation varies with different types of work. Some applications can greatly improve the performance from fragment. Understanding application features, system performance, and SQLThe fragment statistics provided by the server are the key to determining when to perform fragment. SQLServer provides commands to complete index fragmentation. This article helps us determine when and how to sort index fragments to maximize performance.
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.