Remote connection / query

• Pete Softown

  Say Hey Kid

  Points: 689

  More actions

  June 10, 2015 at 7:59 am

  #301392

  Hi all,

  I've searched for this but did'nt found an appropriate answer.

  What is a remote connection and query ? And what is a local connection and query ?

  If i'm on management studio on my pc connected to a SQL Server 2012 that is on a server, am I remote ?

  I didn't had a timeout in SSMS for the following query. Considering the remote query timeout setting is 600

  USE Database_name

  go

  BEGIN

  WAITFOR DELAY '00:11';

  select * from [dbo].[Table_Name]

  END;

  GO

  Thanks

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  June 10, 2015 at 8:43 am

  #1804368

  I hope that following link should help you to understand what is "remote connection"

  https://msdn.microsoft.com/en-US/library/ms191464.aspx

  As for SSMS, go to Tools/Options select "Query Execution" in the left panel.

  You will see that "Execution time-out" is set to 0, which is default and means - no timeout limit.

  You can change it if you like.

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 10, 2015 at 8:48 am

  #1804371

  Remote query timeout affects queries which this SQL Server instance (the one with the setting) executes against other database engines, via ether OPENQUERY or 4-part naming.

  It has no effect on queries which are running locally (queries submitted to it which it is running against its own databases)

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Pete Softown

  Say Hey Kid

  Points: 689

  More actions

  June 10, 2015 at 9:22 am

  #1804384

  Thanks all!