SQL Server

installation SQLServer2005 cluster 1. Install MSDTC, open Control Panel, add removal program, add delete Windows components, select Application Server, select Enable Network DTC Access 2. Add resource MSDTC to cluster manager after

SQL Server backup and disaster recovery The data processing becomes more and more important in the modern enterprise operation, more and more crucial, may even become the enterprise development bottleneck. The importance of data protection is

server| wrong 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 are several possibilities: 1,sql server name or IP address

Are you familiar with the proverb: "When everything is normal, there is always something wrong". That's true, and that's what happened to me. I installed at least more than 10 times visual Studio. NET (vs.net) and SQL Server 2005 under the

access|excel|server| Data | conversion SQL SERVER data conversion with Access, Excel Database administrators familiar with SQL SERVER 2000 know that their DTS can import exports of data, but we can also use Transact-SQL statements for import and

Server A few days ago also encountered a large log file problem, the actual size of the database is 600M, the actual size of the log file is 33M, but the log files occupy a space of 2.8G!!!Try a variety of ways, Shirnk DATABASE, TRUNCATE LOG file,

Updatable view (updateble views) Above we explained "how to read the data from the server through the remote view", then we will explain how to operate the remote view cursor, of course, we will not discuss some of the Visual FoxPro data set of

Just start a new notebook, a busy, loaded system. Small black Drive really many, 7788 also have twenty or thirty files to download, install. Turn to install development software is collapsing, a heap of SP waiting for us to fight! Microsoft left us

Do you know how a large enterprise database server product of SQL Server is created? Here are some related data: The size of each build is around 300GB. Each complete build requires dozens of high-end servers to run for 2.5 days. Each complete

Original: SQL Server local replication subscription for database server read-write separationThe previous paragraph Echosong wrote about MySQL data synchronization to realize the separation of business read and write, today we look at SQL Server

I. OverviewThe simple recovery model and the bulk recovery model are described earlier, and this article continues to write backup and restore under the full recovery model. The biggest advantage in the full recovery model is that as long as the

What is the difference between a SQL Server database and a MySQL database? A lot of friends in the IT industry. For SQL Server database and MySQL database often confuse, think these two kinds of database is the same, otherwise, today we analyze the

As business grows, companies need to improve their data security and performance needs, so they need to pre-research new technologies (first mining pits), and do technical accumulation:Learn about AlwaysOn failover Clustering (hot standby), data

I. SQL Server Error 18452 MSSQL error 18452Solution:1. log on to sqlserver2005 with a Windows Account2. Right-click the top root directory on the left. properties. (server properties)3. a) Select security first.B) Select SQL Server and Windows

Microsoft SQL Server Error: 15138 failed to delete the database because the database owner has a schema in the database and cannot delete the database. Solution An error occurred while deleting the *** user. (Microsoft. sqlserver. SMO) Click:

This articleArticleThis is the second article in the series, in case you have not read the first article. The address of the previous article is as follows: Transaction logs in SQL Server (I)-physical and logical architecture of transaction logs

Know "query analyzer" Start the Service Manager and open the Enterprise Manager. Select the database to be operated (taking my sky2098 as an example), and select "SQL query analyzer" in "Tools" on the menu bar ": If the "Object Browser" on the left

In addition, the configuration of merging and copying was studied last night. The environment I need is like this. The server-side database adopts SQL Server 2000. The PPC client adopts the streamlined Database SQL Server mobile edition.Currently,

This article describes in detail how to optimize SQL Server database queries. There are many reasons for slow query speed in SQL Server databases. The following are common causes: 1. No index or no index is used (this is the most common problem of

Several problems encountered when reading Excel in the sql2005 query analyzer, collected all the resources on the Internet, and finally solved the problem. Many answers on the Internet are pasted and copied, therefore, it cannot be used in the