SQL Server

When installing SQL Server 2000 in c: \ windows \ sqlstp. log, the following error message is displayed:========================================================== ==================== Driver = {SQL Server}; server = Soyo; uid = sa; Pwd =; database =

Data import and export is one of the common tasks of database administrators, especially the import and export of flat files. The BCP tool provides strong support for these tasks. It is based on DB-library, especially in the production environment,

-- Requirement Description: /* Id col -------------------- Ab00001 Ab00002 B -- When data is inserted, the ID is automatically changed to ab00003. */ -- 1. Calculate the maximum value (this method is not applicable when high concurrency is

Set quoted_identifier onGoSet ansi_nulls offGo Create procedure sp_password@ Old sysname = NULL, -- the old (current) password@ New sysname, -- the new password@ Loginame sysname = NULL -- user to change password onAs-- Setup runtime options/declare

/// /// obtain the names of all database instances with the specified IP address. /// /// specifies the IP address. /// username used to log on to the database. /// password used to log on to the database. /// Returns a list of data

Method 1 (sqldmo is not used ): ////// Backup method///Sqlconnection conn = new sqlconnection ("Server =.; database = Master; user id = sa; Password = sa ;"); Sqlcommand cmdbk = new sqlcommand ();Cmdbk. commandtype = commandtype. text;Cmdbk.

SQL ServerThere are two backup methods, one is to use backup DatabaseBack up the database files, and copy the MDF and LDF of the database files directly. This article describes the backup and recovery of the latter. This article assumes that you are

Problem: the background system needs to connect to SQL Server, and the instantaneous data operations may be very large, as if tens of thousands of data needs to be inserted into the database, however, when data is inserted, other threads may need to

Reference sqlclient. dll under WinCE Add dbnetlib. dll You can operate a remote database at will.   Dbnetlib. dll: http://download.csdn.net/detail/tiz198183/4344983 1. copy and paste dbnetlib. DLL to the vs project. 2. Set the properties of dbnetlib.

Recently, some customers want to listen on the number of connections of SQL Server. I summarized the following methods (the heroes in the hope garden provided some suggestions) 1. obtain the maximum number of concurrent user connections allowed by

The bitwise operation function of SQL Server cleverly solves multiple-choice queries Data Tables of many business objects in the project have the Status field. Some use the int type to save the status, while others use the varchar type. Whether Int

SQL Server Management is closely related to Windows Management. it is sometimes very convenient to manage SQL server through the Windows registry. I will share some of my long-term use or favorite registry skills (note: all projects are verified

Method 1: Symptom: the database log is too large, so the shrink cannot be dropped. So I want to unload the database file, delete the log, and attach it. Attaching failed. Error message: Server: Message 1813, level 16, status 2, Row 1 The new

The memory of SQL Server also affects performance. If too much memory is in the SQL server system, it is a waste of money. If the memory is too small, it is very harmful to performance. Unfortunately, it is very flexible to decide when you need more

Use adventureworks2008r2; godeclare complex_cursor cursor for select. businessentityid from HumanResources. employeepayhistory as a where ratechangedate <> (select max (ratechangedate) from HumanResources. employeepayhistory as B where.

Simple but accurate following script will give you list of all the indexes in the database which are unused. if indexes are not used they shoshould be dropped as indexes when CES the performance for insert/update statement. indexes are only useful

Let's talk about the monitoring values. The baseline captures those values. How to Make an alarm Environment: Windows 2008r2, SQL Server 2008r2 SP1 Performance baseline: CPU: \ Processor (_ total) \ % processor time\ Processor (_ total) \ %

From: http://blog.csdn.net/yangzhawen/article/details/8209167 18056  The client cannot re-use the session with spid % d. The session has been reset for the connection pool. The failure ID is % d. This error may be caused by a previous operation

There are many differences between the returned results of forward T and not in on the Internet. It mainly describes the performance differences between consumer T and not in. CREATE TABLE tb1(ID int) CREATE TABLE tb2(ID int)BEGIN TRANDECLARE @i

1. scalar functions 　　1) Create Create Function fun_max (@ x int, @ y int) -- scalar function returns int asbegin if @ x Create Function fun_max (@ x int, @ y int) -- scalar functionReturns intAsBeginIf @ x Set @ x = @ YReturn @ xEnd　　2) CallDeclare