sql 2000

When the log file is full and the SQL database cannot write the file, you can use either of the following methods:One method: Clear logs.1. Open the query analyzer and enter the commandDump transaction database name with no_log2. open the Enterprise

Stingy god 2001- Well, I think there should be some conclusions about the entire topic after this article. However, the specific circumstances may vary and the environment may be different, so it is just a feeling.DotNETSome of the

An unlimited menu is used in a recently developed project, so this code is pasted for research. The development environment is VS2008 + SQL 2000. First, the code for creating a database table is as follows:Database Table code of the infinite level

One mysql small exercise table creation query and modification table added field deletion Field One mysql small exercise table creation query and modification table added field deletion Field I had nothing to worry about. I found an exercise to

SQL Server Index reconstruction, SQL Server Index The company's online data has tens of millions of data records. Sometimes index fragmentation may cause indexes to fail to meet our expected query efficiency. At this time, re-indexing will improve

Case subquery connection query is a frequently used query function in SQL development. If you are interested, do not miss this article. Next we will introduce it in detail. Case subquery connection query is a frequently used query function in SQL

Definition: What is a trigger? In SQL Server, certain operations on a table trigger certain conditions to execute a program. A trigger is a special stored procedure.There are three common triggers: Insert, Update, and Delete events.Why should I use

Use distributed functions OpenDataSource OpenQuery OpenRowSet Processing distributed databases, writing programs is relatively simple, but the configuration of DTC is complicated. I checked MSDN for evidence. I wrote a program for simplicity and

[Topic] On a large website, there is a table that stores news records, with a database volume of about 50 thousand (not big in fact). News on the website pages are dynamically produced from this table, and there are also 80 ~ News from 90 websites

/* Create a virtual test environment, including the table [cigarette inventory table] and table [cigarette sales table]. Please pay attention to tracking the data of these two tables and understanding what business logic the trigger has executed and

I plan to know about CommunityServer, So I downloaded a 2.1 version today. But it's a big deal! Some errors occur during the process. Problems encountered during SQL Execution In this process, follow the instructions in

Vmware vsphere FAQs and SolutionsDate: 2012-6-29 Source: 51ctoVmware VSphere12　　1. The virtual machine file is locked and cannot be properly power onFault Status:Starting a virtual machine 95%, pausing and process interrupted, tip: ubable to access

The current workaround is to remove the other files on the hard disk to empty the hard disk space, change the database log file size to unrestricted, and then separate the database, to ensure that the separation is successful, and then delete the

Because your development environment uses MS SQL Server 2005, and the server is still deployed with MS SQL 2000, you have to import MS SQL Server 2005 into MS SQL Server after system development is complete 2000, although the same Ms family of

A data dictionary is a collection of related descriptions of data and objects in a data model that helps programmers and users look up data and objects when they create applications and reports. When you use the data model, it is ideal to create a

LINQPad supports all functions of C # 3.0 and Framework 3.5: LINQ to SQL LINQ to Objects LINQ to XML LINQPad is also a good learning LINQ tool, containing 200 examples from the book "C # 3.0 In a nutshell," which can use LINQPad to feel the cool

When the log file is full and the SQL database cannot write to the file, there are two methods available: One way: Empty the log. 1. Open Query Analyzer, enter command DUMP TRANSACTION database name with NO_LOG 2. Then open Enterprise Manager-right

A few days ago, when I upgraded a communtiy Server database from SQL 2000 to SQL 2005, I ran into a weird problem that reported the following error: violation of PRIMARY KEY constraint ' pk_cs_threads '. Cannot insert duplicate key in object '

If you are accustomed to using Windows database, that is, in the graphical interface to manipulate the database, then when you operate on the command MySQL will be unfamiliar, in fact, as long as you master some basic commands, and often used,

1, the installation of MSSQL using mixed mode, of course, the SA password best can not be empty, in the SQL2005, the SA can be modified or deleted super User name.Use masterAlter LOGIN [SA] with NAME=[ZXS]/* Modify SA Account * *Sp_password ' 111111