Post reply

Remote connection / query

  • 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

  • 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]

  • 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

  • June 10, 2015 at 9:22 am

    #1804384

    Thanks all! 😀

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply