Basically SQL Server As long as you're dealing with a lot of data , Such as INSERT INTO A SELECT * FROM B When there's a lot of data , It's easy to happen Timeout , That is, common 「 Overdue 」 error .

SQL Server For this machine Enterprise Manager It's easy to handle if it's implemented , Just change the settings .( Tools -> Options -> Advanced , Increase the timeout seconds ).

But most of it is in Remote Next SQL Command , Just a little bit more , such 「 Overdue 」 The probability of occurrence also increases .

The best solution is to increase SQL Server Remote Command Of Timeout Time , As long as SQL Queryer Inside down :

USE master
GO
EXEC sp_configure 'remote query timeout', 6000
GO
RECONFIGURE
GO

6000 It's the number of seconds , That is to say 6000 second (SQL Server The default is 600 second ,).

The other is to use external programs to deal with , But it may still be limited to SQL Server The limitation of , especially ADODB There are serious problems in this part Bug, See :

PRB: CommandTimeout Does Not Inherit From Connection Timeout
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195489

Program setting CommandTimeout Examples of processing :

Dim conn As New ADODB.Connection
conn.Open(ConnStr)
conn.CommandTimeout = 600  ' second 
conn.Execute("INSERT INTO A SELECT * FROM  B")
conn.Close()
conn = Nothing

It should be noted that ADODB 2.6 before ,CommandTimeout It can't be set to 0 ( Unlimited time ), If you have to use it , You have to use ADODB.Command, See :

FIX: Use Connection Object CommandTimout Attribute problem
http://support.microsoft.com/default.aspx?scid=kb;zh-tw;175264

[ turn ]SQL Server 「 Overdue 」 More articles on how to deal with

  1. With the SQL Server A network related or instance specific error occurred while establishing the connection

    stay visual studio When adding a database application to , Report errors , The tips are as follows : With the SQL Server A network related or instance specific error occurred while establishing the connection . Server not found or unreachable . Verify that the instance name is correct and SQL ...

  2. With the SQL Server A network related or instance specific error while establishing a connection

    The customer has a problem , use “ Server name \ Instance name ” Remote connection to another named instance failed , newspaper “ With the SQL Server A network related or instance specific error while establishing a connection , Server not found or unreachable . Please verify that the instance name is correct ...

  3. SQL SERVER 2008 Cannot be called on control during installation Invoke or BeginInvoke error resolvent

    perhaps  SQL SERVER 2008 Restart required during installation , However, it is still required to restart after restart . You can use this method . Of the registry "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet ...

  4. And SQL Server A network related or instance specific error occurred while establishing the connection .

    Today, my classmates asked me why the database could not be opened , open SQL Server 2008 Of SQL Server Management Studio, Input sa My password discovery , Can't log in to the database ? Here are some mistakes : " stay ...

  5. Use SQL Server 2014 Memory database need to pay attention to the place

    author Wang Feng published in 2014 year 7 month 4 Japan From the perspective of product design and architecture, this article shares Microsoft Experience in using in memory database , I hope you can understand these new objects after reading this article . Concept , To better design your architecture . In-memory database , Refers to ...

  6. Restore or delete sql server 2008 Database time , It often comes out : “ Because the database is in use , So you can't get exclusive access to the database ”, The final solution

    Restore or delete sql server 2008 Database time , It often comes out : “ Because the database is in use , So you can't get exclusive access to the database ”, The final solution is as follows The key SQL sentence : ALTER DATABASE [dateba ...

  7. encounter sql server How to find out the problems of

    The First Things I Look At On A SQL Server and Page2 It introduces how to meet sql server How to check the problem when solving the problem ,Display Code Lists sql Code . Includes the following ...

  8. Remote connection SqlServer The database prompts " With the SQL Server A network related or instance specific error occurred while establishing the connection " resolvent

    Preface Because in my previous career , Whether it's a database or a development environment , It's all done by predecessors , Just use it yourself . I don't know that there will be all kinds of errors in the installation process . After contacting the server recently , All aspects of the development environment and configuration are installed from scratch to configuration ...

  9. Sql server On another server , stay Visual Studio No problem ,IIS in Tips “ With the SQL Server A network related or instance specific error occurred while establishing the connection ....”

    Maybe question one : To be exact, it is in IIS 7.5 There's a problem with it Is in the visual studio It's all well used in the classroom , But loading into IIS I made a mistake when I was on the Internet “ With the SQL Server When establishing a connection, network related or real specific ...

Random recommendation

  1. os.environ()

    ---------2016-5-9 18:56:39-- source:OS.ENVIRON() Detailed explanation

  2. oracle Query database table space size and remaining space

    dba_data_files: Database data file information table . You can count the table space size ( Total space size ). dba_free_space: You can count the size of the remaining table space . Adding a table space means adding data files to the table space , The table space size is the data file ...

  3. modelsim(2) - vcd (dump, see , Format understanding )

    Two vcd dump because VCD It can be used for power analysis , So it needs to be dump come out . in addition VCD As a result , It can also be used as an incentive , But actually see less ! VCD yes verilog Standards for , So there are system functions $dumpvar ...

  4. 【HDOJ】4056 Draw a Mess

    This problem is solved by using line segment tree MLE. The idea is reverse thinking , Then each segment is removed by using and searching the set , The average complexity is O(n*m). /* 4056 */ #include <iostream> #include &l ...

  5. ORM query language (OQL) Introduction advanced

    ORM query language (OQL) brief introduction -- Advanced : Thoroughly remould oneself Before writing this article , I've been thinking about how to get the title of the article . In the writing <ORM query language (OQL) brief introduction -- Concept >.<ORM query language (OQL) brief introduction -- Case study ...

  6. Talk about Nancy What people love and hate Diagnostics【 Part 1 】

    Preface stay Nancy There is a very good function in -Diagnostics, It can be said that this function makes people love and hate . Maybe we've all tried the following : Record the relevant technical information used in a function Record the visit records of the website Global configuration of certain boxes ...

  7. ABP From entry to mastery (6): Quick rename solution

    SolutionRenamer SolutionRenamer Is a solution quick rename tool . After testing, rename a brand new asp.net zero core project (ABP asp.net zero,.net c ...

  8. Fiddler Grab and modify WebSocket data , Support wss

    Record it with Fiddler Yes WebSocket Send and receive data packet capture analysis and tamper with data , There's only one way , Just use it . Time :2019-3-29 Environmental Science : win7 + Fiddler 5.0 Fiddler Catch ...

  9. iptables Addition, deletion and modification of

    iptables yes linux The firewall of the system , Powerful , It takes a while to learn , Here are some habits iptables A record of the time when I was a child . If iptables If you are not familiar with it, you can use apf, It's based on iptables The firewall of , ...

  10. One a day linux command :scp command

    scp yes secure copy Abbreviation , Used in Linux Under the command to copy files remotely , Similar orders are cp, however cp It's just that copying on the local machine can't cross servers , and scp The transmission is encrypted . It may affect the speed a little . When you're on the server ...