sql 2000

Document directory Don't panic Do not separate databases Do not restart the Database Service Do not rush to run REPAIR Run integrity check Root Cause Analysis Database File Corruption may be the biggest headache for DBAs. In this article,

I. Page and Disk Area ): All information in SQL Server is stored on the page. Except transaction logs (which are composed of a series of records), the page is the minimum data unit used in the database, each page stores 8 KB of information. SQL

1. Backup data: Back up SQL 2000 data, please back up the SQL 2000 database directory (default in C:\Program Files\Microsoft SQL Server\MSSQL\Data), if you also open user databases in a different directory, such as D:\SQLDATA, Also, back up this

1, because the SQL2000 installation process can not modify the instance name, so the installation process must first install SQL2000, and then install sql2005. You must modify the SQL instance name when you install sql2005, otherwise it will

In the previous introduction of SQL2K has been mentioned in the SQL2K of XML support, using the FOR XML statement can easily translate the results of execution into an XML, which can greatly improve the efficiency of the system and development speed,

xml| generation of XML before the introduction of SQL2K has mentioned the SQL2K support for XML, the use of XML statements can easily translate the results of execution into an XML, which can greatly improve the efficiency of the system and

1 Introduction In the observation of the current stage, the school's various test papers are used in the traditional manual out of the way, the teacher each of the papers need to refer to a variety of related books, consider the difficulty of the

Create PROCEDURE [dbo]. [Proc_getpagelist](@Tables varchar (1000),--table name@PK varchar (100),--primary key@Fields varchar (1000) = ' * ',--the field of the query@SortField varchar = NULL,--sorted fields@SortType varchar = ' ASC ',--sort

Due to system requirements, I recently moved the system from MySQL to SQL 2000 during the development process. I encountered many problems and it took me a lot of time. Now I will show you my experience so that you can avoid detours and save

First, back up the original master website and pay attention to backing up the freehost database, database backup, and Another easier way: If you reinstall SQL 2000 on the same server, you can back up the file in the entire SQL 2000 directory and

Due to system requirements, I recently moved the system from MySQL to SQL 2000 during the development process. I encountered many problems and it took me a lot of time. Now I will show you my experience so that you can avoid detours and save

There are some problems with the original in SQL 2000. Fix the error and run through in SQL 2000. /******************************************************** Author: (wleii165@yahoo.com) Version: 1.0 Creation Time: 20020227 Modification Time: Function:

First, let's talk about the connection between SQL 2000 and SQL 2005 when using the rack package developed by Microsoft to connect the ms SQL Server database; 1. The drivers are different first. There are three connection drivers for SQL 2000:

The SQL2000 Enterprise Edition is applicable to Windows 2000, and the 2003 and XP systems generally cannot be installed with the individual edition. Of course, if you have worked hard to download the Enterprise Edition, you cannot install it, are

I will discuss it in several aspects. I tried and verified it multiple times. Database: Q: How can I check whether my physical machine (for example, the xp I use) is connected to a Linux-connected and shocking service connection? Are there any

When you have installed the "extraterrestrial virtual host management platform" Software, for special reasons, you need To reinstall the 2003 operating system, you can follow these steps: -------------------------------------------------------------

server|sqlserver| Stored Procedures Author:zfive5 (Zhaozidong) email:zfive5@yahoo.com.cn Recent work reasons write stored procedures, coding is unavoidable debugging, but SQL Server debugging of the Fool degree is simply not Compared to Oracle,

Some of the new features of SQL Server 2008 and its uniqueness:Set up and installSetup and installation of SQL Server 2008 are also improved. Configuration data and engine bits have been separated, so it makes it possible to create a disk image of a

First, please back up the original master site and note to back up the Freehost database, the database backup, there Another easier way: If you reload SQL 2000 on the same server, you can back up the entire SQL 2000 directory file and rename it to:

Latest information: the latest batch of members have been added. In addition, you need to provide your account in the blog garden for wujunwei and xpelive, which does not seem to exist in the blog garden. Users with incorrect information have fixed