cannot find sql server on network

Address: http://blog.csdn.net/zjcxc/archive/2005/07/06/415711.aspx Author: zhujian1. How to understand SQL Server instances In the project implementation process, many users need to develop a new SQL Server-based system. After the system is accepted,

For more information about bugs fixed in SQL Server 2000 Service Pack 4, click the following article number to view the article in the Microsoft Knowledge Base:314128 FIX: When an RPC call is performed, Access with conflicting values includes an

Original: SQL Server connectivity Issue-TCP/IPOriginating From: http://blogs.msdn.com/b/apgcdsd/archive/2012/02/24/ms-sql-server-tcp-ip.aspxBasic principles of how TCP/IP works here's not a waste of saliva. Now this network age, who does not know

Because server A cannot see the witness server W or the original mirror partner server B, you must enter the disconnected state and make the database unavailable. Server B and Server w can compose quorum. Server B cannot see server A, so Server B

SQL2005 failed to start SQL Server Request or service failed to respond in time Disable the VIA protocol to solve the problem. "VIA protocol" Deactivation method: start-> Program-> Microsoft SQL Server 2005-> Configuration tool-> SQL Server

Original address: http://www.cnblogs.com/lyhabc/p/3367274.htmlBefore reading this article, you can read the following article firstSQL Server's unique task scheduling algorithm "Sqlos"Task Scheduler for SQL Server Sqlos [go]Translated

In keeping your servers and data secure from the current complex attacks, SQL Server has everything you need. But before you can effectively use these security features, you need to understand the threats you face and some basic security concepts.

1. If you are using win2003, you must install the SQL patch sp3a. Check whether your SQL has been patched. If not, install a patch. You can run the patch in the query Analyzer:Select @ versionIf the version is earlier than 8.00.760, it indicates

Original: SQL Server connectivity issue-Named pipesOriginating From: http://blogs.msdn.com/b/apgcdsd/archive/2011/01/12/sql-server-1.aspxOne. ObjectiveIn the process of using SQL Server, the most users encounter is the connection problem. This

MS SQL Server Query optimization methodThere are many reasons for the slow speed of queries, which are common1, no indexes, or no indexes (this is the most common problem with query slowness, is the flaw in programming)2, I/o throughput is small,