SQL Server

Today, we learned from SQL Server everywhere blog that Microsoft SQL Server 2005 everywhere edition Access Database synchronizer (ADS) CTP has been released.ADS provides a solution for data synchronization between access databases on the desktop and

In the past two days, I have been thinking about changing the SQL Server express Edtion that has been used for a long time, because it is a free version and has many functions, including the usage is not very good, however, I am confused about a lot

For example: Show notepad content Show database fields InProgram(Select "Upload File" and click "Upload". The file location is displayed in the text box. Click "publish" to publish the notepad data to the database ): Upload button

Today, when attach a previous database (not in the directory where sqlserver is initially installed), it is always unable to be attached, and there is always a 5123 error.Code, At first, I thought it was because sqlserver2008 was not compatible

Sometimes we need to know the file number and page number of a record stored in the table, but after our own query, it is a hexadecimal page number, then how can we calculate the "file number" and "page number" of the Record Based on the hexadecimal

After the SQL Server database is restored from the backup file. Bak and recovered, an error is reported during query: SQL server detects a consistency-based logic I/O error. SQL server detects that the consistency-based logic I/O error checksum is

When reading or modifying data in the database, the database engine uses a dedicated control type to maintain the integrity of the database, which is called the lock mechanism. The lock mechanism ensures Database Consistency by ensuring that the

Two days ago, I arranged for a customer to provide services. I encountered an error where ODBC could not connect to SQL Server 2000. The following error may be detected: One possibility is the SQL bug. The two may be the English version of the

Agent job   1. about SQL server agent use SQL server to store job information. A job contains one or more job steps, each of which has its own job. SQL server the agent can run jobs as scheduled or run jobs in

ASP. NET database operationsCodeDatareader Function: datareader reading class, which reads data only forward. Read-only and inbound data streams. Because there is only one row of data in the memory each time, you can use datareader to improve the

For ms SQL Server databases, there are several problems that are easy to misunderstand. For these problems, even if many SQL Server DBAs have incorrect understanding or insufficient understanding, therefore, I want to write a few articles to

I am a little embarrassed about sqlce installation. Why? Since I first learned how to use the. NET companct framework, I have been exposed to sqlce. At that time, there were two difficulties. One is sqlce installation and the other is Program . Of

SQL Server Dynamic Cursor Declare @ SQL varchar (2000 ), @ Typefield varchar (100 ), @ Tablename varchar (255 ), @ Name varchar (100) Select @ typefield = 'name', @ tablename = 'sysobjects' Set @ SQL = 'Clare cutemp cursor' + 'Select distinct '+ @

Java writes text, ntext, and image fields to the SQL Server database. When the data volume is too large, you can use the updatetext statement to insert data in segments.   Person ;//ThePersonObject Inputstream input; // personThePhoto,

Several solutions have been used for database paging over the years, which are summarized as follows: 1. Use the row_number function and temporary table paging. SQL 2005/2008 is applicable. The general idea is as follows: Select *, row_number (

/* Data operations between different Server databases */-- Create a linked serverExec sp_addrole server 'itsv', '', 'sqloledb', 'remote server name or IP address'Exec sp_add1_srvlogin 'itsv', 'false', null, 'username', 'Password'-- Query

If you are interested in MSSQL user information, you may find the Master. DBO. sysxlogins stores user passwords. However, if the password field is not null, It is a bunch of binary files that cannot be understood. How is this password encrypted?In

Auto: http://www.dabaoku.com/jiaocheng/biancheng/mssql/200910111334.shtml Recently, the database server has increased its memory to a maximum of 8 GB, and the database uses MSSQL 2005. Previously, the memory was 4 GB, there is no conflict between

1. view the database versionSelect @ version2. view the operating system parameters of the machine where the database is locatedExec master .. xp_msver3. view database startup parametersSp_configure4. view the database startup timeSelect convert

1. What is a named pipe? Like TCP/IP (transmission control protocol or internet Protocol), a named pipe is a communication protocol. It is generally used in Lan, because it requires the client to have the permission to access server resources. To