23. Access Microsoft SQL server from the Internet
Internet programming concepts
Use ISAPI to access SQL Server
Use ASP to access SQL Server
Use XML to access SQL Server
Summary
Using Microsoft SQL Server 2000 on the Microsoft Windows 2000 operating system platform allows us to easily publish SQL Server database to the Internet. The combination of Windows 2000 and
Summary This article lists the default permissions on the drive after formatting with the NTFS file system for the first time. Some of these folders are hidden by default. The default NTFS permission on the Windows 2000 public folder in drive C is listed below. Note that this document assumes that Windows 2000 is installed on drive C. If you install Windows 2000
1. Preparations before installation
1) Make sure that Windows 2000 has been upgraded to the domain controller and the Active Directory is installed ). Assume that the computer name of the Server is "Server", "Domain" is named "edu", and "Domain Name" is "enanshan.com ", the local "Active Directory domain name" is "edu.enanshan.com", it will also be the mail server name), and "complete computer name" is "server.edu.enanshan.com ".
2) ensure that NNTPN
Enable services through the Windows 2000 Professional RegistryEnable the service through the registry of Windows 2000 Professional Edition
By Jim BoyceBy Jim BoyceTranslation:Purleendurer
Keywords: Windows 2000 | desktopsKeywords: Windows 2000 | desktop (system)
Http://techrepublic.com.com/5100-10877_11-6091320.h
I. preparations:
1. Prepare the installation disc for Windows 2000 server Simplified Chinese version, and check whether the optical drive supports auto-start.2. if possible, use the disk scan program to scan all hard disks to check hard disk errors and fix them before running the installer. Otherwise, it will be troublesome to check hard disk errors during the installation process.3. Record the product key (installation serial number) of the Installa
New features provided by DNSSupports Active Directory AD)Unlike NT 4.0, the domain name of the Active Directory in Windows 2000 Server adopts a DNS name similar to that in the Internet, and the DNS is integrated into the design and implementation of the Active Directory. If the Active Directory is installed on the Server, Windows 2000 Server automatically installs and configures the DNS service for the Acti
Determine the installed SQL Server 2000 Database Components version
Use isql, osql, or query analyzer to Perform one of the following queries on Database Engine instances.
Select serverproperty ('productlevel ')
SELECT @ VERSION
Select serverproperty ('productversion ')
Use the following table to determine your Database Components version.
SQL Server 2000 VERSION and level/@ VERSION/product level
Original S
How Excel 2000 creates a list of data:
In Chinese Excel 2000, sorting and filtering data records takes place through a list of data, so you should create a "list" before you can manipulate it. A list is a series of rows of data that contains related data in a worksheet, such as the "Employee Payroll" set up earlier, which contains rows of data that can be browsed and edited like a database. This is similar
server| Data | database
One, data file type:
Each SQL Server 2000 database has a master data file that can have multiple secondary data files, which can only be used by the database.
Second, the data file name:
Each data file is a stand-alone operating system file. The main data file is usually a file suffix with. mdf (this suffix is not required, but is useful for identifying files). The master data file stores the data in a table or index, which
Windows 2000 was formerly known as Windows NT 5.0, and with the release of a variety of beta versions, people began to deepen their understanding of it from all sides. The new interface, highly integrated functions, consolidated security, convenient operation, all of the computer professionals, ordinary users bring great surprises. Before it was officially released, the Global Computer magazine was full of
Shaoxing, discuss its article.
This chapter
Because Windows XP is published after Windows 2000, software is not usually compatible with future versions, and if for some reason you install Windows on a machine that has successfully installed Windowns XP 2000, the latter will overwrite the hard drive's primary boot sector and the system files in the system disk directory, causing the previously installed Windows XP to fail to start. It is usually repor
Recently, a foreign website has posted a short optimization guide to teach you how to install and run Windows 2000 on a 32 MB system, which is useful for many users who still use the semi-"Antique" system.
Before optimization: it takes 30 seconds for Windows 2000 to start up, and 3-4 MB of memory is left for the software to run. The system's response speed makes people want to commit suicide.
After optimiza
I have been asking questions for some time and have hardly given me any valuable contributions. I have always felt a little inactive. Based on some of my experiences and experiences, I have summarized the windows Startup Password cracking issue and hope to help you.
These three systems are all NT kernel, so I will explain the problem together. All methods to crack the 2000/NT password are applicable (NT is rarely used, please correct me if there is an
Account Management is an important guarantee for network security. network administrators on campus networks certainly know this, so they will certainly protect their administrator accounts well, however, network administrators can easily ignore small but not small problems.Generally, you must have a valid account to log on to Windows 2000. Because Windows 2000 Server provides different access permissions f
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, the script is mainly a filtering problem. It needs to filter characters such as '; @/to prevent atta
Disable socket pooling in Windows 2000 Server
Disable socket pool in Win 2000 Server
By Jim Boyce
By Jim BoyceTranslation: purpleendurerKeywords:Windows 2000 | Internet | servers | Web Servers
Keyword: Windows 2000 | Internet | Server | Web Server
Http://techrepublic.com.com/5100-10879_11-5841376.html? Tag = NL. e116
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
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.