microsoft sql server

Server Steps for how to install the SQL Server 2000 basic components locally. Install SQL Server 2000 To install the basic components of SQL Server 2000 locally 1. Insert the Microsoft SQL Server 2000 installation CD into your CD-ROM drive (if the

server| Data | database The steps that you must perform when the transaction log expands to an unacceptable limit. The extension of the transaction log will cause the Microsoft SQL Server database to become unusable. In SQL Server 2000, each

1, determine the SQL database installation path and the SQL database name used. such as: e:\Program Files\Microsoft SQL Server\mssql\data\j200.mdf ' 2, the database J200 renamed to other names, such as J2008, what names can. 3. Use the system you

Problem Description: There is no aggregate function for strings in SQL 2000 or in SQL 2005, so it's a hassle when we're dealing with the following requirements: There are table TB, as follows: ID value ----- ------ 1 AA 1 BB 2 AAA 2 BBB 2 CCC Need

Data | database | Data synchronization Using database replication technology to realize data synchronization update The concept of replication Replication is the technique of copying a set of data from one data source to multiple data sources, and

--assuming Test2 is the database name The log is already very large when used Method One This method applies to 7.0 and 2000. 1. Executing in Query Analyzer: exec sp_detach_db ' db_name ' 2, in My computer in the log of the physical file

Ado|server prevents an implicit connection when ADO connects to SQL Server Date:2002/9 Prepared by: Zheng Article last modified on 2002-9 The information in this article applies to: Ümicrosoft SQL Server 2000,7.0 Ümicrosoft ADO 2.5 Problem

server| process Microsoft SQL Server 7.0 storage process Debugging Guide Summary: Describes how to use the Microsoft Visual InterDev SQL Debugger to clear errors in the Microsoft SQL Server storage process. Using Visual InterDev to clear errors in

server| access using HTTP to access SQL Server You can use HTTP to access Microsoft®sql server™2000. Before you can specify queries using HTTP, you must first create a virtual root with the IIS virtual Directory Management utility for SQL

server|web| tips for "Data Library" search: Use the like language of SQL instructions, or Microsoft SQL Server 7.0 's Chinese full text search feature. Microsoft Index Server The Microsoft Index Server, included in the Windows NT Option Pack,

Solution | design | Problem as Microsoft launched the Web page and database solutions, ASP because of Microsoft's unique operating system and other technical backing support, it has been rapid development, and is receiving more and more welcome, in

asp.net [foreword:]asp.net is the latest technology for developing web-based applications from Microsoft. It provides a number of benefits over traditional ASP scripting technologies, including: (1) A better development structure is established by

Tips | Scripting If you're an adventurer and you're running PHP on a CGI, ISAPI, or Apache version of a Windows system, you can also get the COM functionality of the system. Now, the job of interpreting COM (Microsoft's Component Object model) has

asp.net 　　 first, the introductionAs early as 2001, I started to develop a asp.net online messaging board application webforums.net. The goal is to create a asp.net message board system that can easily be plugged into an existing Web site. One of

dom|js|xml| Data | database | conversion First, JDOM introduce We know that the DOM is the official consortium of standards for representing XML documents in a platform-and language-independent way, using the DOM and Sax APIs to parse and

server| Error I ran into a mistake yesterday when I installed SQL-- Title:microsoft SQL Server the Setup------------------------------ The SQL Server System Configuration Checker cannot is executed due to WMI Configuration on the machine XXXX (0x8004

server|sqlserver| sort SQL Server collation is not usually used a lot, perhaps many beginners are still relatively unfamiliar, but thereAn error should be often encountered: SQL Server database, in the cross-Library multiple table connection query,

Server| stored Procedure | data | database Many friends may have been using SQL Server for development for some time, but have not or rarely used the stored procedures in the project, perhaps some friends think that there is no need to use stored

Solution | data | Database First provides a complex method for compressing logs and database files as follows: 1. Empty log DUMP TRANSACTION Library name with NO_LOG 2. Truncate the transaction log: BACKUP LOG database name with NO_LOG 3. Shrink

server| Error Four of the most common errors in SQL Server connections: One. " SQL Server does not exist or access is denied " This is the most complex, the cause of the error is more, need to check the aspect also more. Generally speaking, there