http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8505.aspxThu, 18 Nov 2010 16:02:40 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8505werty800http://sqlserver.ro/forums/thread/8505.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8505Gata am gasit, ms oricum de raspunsuri cu ping am incercat cu xp..cmdshell dar tot la fel ingreuna procedura si ping dai in eth nu in linked server(poate sa fie corupt,oprit serviciul SQL). Am gasit optiune de connection timeout in setarile linked server .<br>http://sqlserver.ro/forums/thread/8503.aspxThu, 18 Nov 2010 10:08:21 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8503B_gd_n[ ]Sahlean0http://sqlserver.ro/forums/thread/8503.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8503<BLOCKQUOTE><div><img src="http://sqlserver.ro/Themes/default/images/icon-quote.gif"> <strong>werty80:</strong></div><div>Chiar asa este facuta procedura doar ca in cele 20 sec nu mai pot accesa procedura stocata.<img src="http://sqlserver.ro/emoticons/emotion-12.gif" alt="Angry" /><br>Cum as putea sa minimalizez aceste 20 sec .<br></div></BLOCKQUOTE> <br /> <br />Incercati sa modificati abordarea: daca procedura stocata este apelata de pe o aplicatie client folositi un API (de exemplu WMI) pentru a verifica daca linked-serverul este down sau/si daca serviciul SQL este pornit. Sau un API care incorporeze o functie/metoda tip ping. Daca aceasta verificare se realiezeaza cu succes atunci apelati procedursa stocata dorita.http://sqlserver.ro/forums/thread/8502.aspxThu, 18 Nov 2010 06:56:51 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8502werty800http://sqlserver.ro/forums/thread/8502.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8502Chiar asa este facuta procedura doar ca in cele 20 sec nu mai pot accesa procedura stocata.<img src="http://sqlserver.ro/emoticons/emotion-12.gif" alt="Angry" /><br>Cum as putea sa minimalizez aceste 20 sec .<br>http://sqlserver.ro/forums/thread/8498.aspxWed, 17 Nov 2010 21:00:34 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8498B_gd_n[ ]Sahlean0http://sqlserver.ro/forums/thread/8498.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8498[1] Probabil cele 20/30 de secunde reprezintă timeout-ul conexiunii.<br><br><a href="http://blogs.msdn.com/b/sqltips/archive/2005/06/07/426578.aspx?wa=wsignin1.0">[2] Test linked server connection settings...</a><br>http://sqlserver.ro/forums/thread/8497.aspxWed, 17 Nov 2010 12:59:38 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8497werty800http://sqlserver.ro/forums/thread/8497.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8497Am o procedura stocata care ruleaza <span style="visibility:visible;" id="main"><span style="visibility:visible;" id="search"><em>sys</em>.<em>sp_testlinkedserver&nbsp; <b>pentru a testa conectivitatea cu un linked server . <br>Problema e ca atunci cand linked serveru este down </b></em></span></span>procedura stocata nu mai poate fi apelata timp de 20-30 sec.<br>Am incercat try catch acelasi rezultat.<br>Astept sugestii!!!! sau cum as putea sa minimizez acest timp.<br>