Prev: Long execution time for UPDATE tbl SET @var = col = {expression} under SQL2000
Next: Is there any way to check GRANT VIEW DEFINITION ?
From: Coigné Guillaume on 9 Mar 2010 03:14 Hello, I have both SQL server 2005 that have replication set-up between eachother. It seems that when my site-to-site VPN drops for a medium period (such as 1hr, 2hr) bothe servers no longer respond to client connections. Restarting the "SQL server Browser" service on both machines instantly resolves the problem. Extra info: Both servers reside in their own site with in each site 2DC (1 GC per site + 1 DC) Is there a way of solving this issue ? -- Guillaume Coign� MCP, MCTS, MCSA, MCSA Messaging Cafe.be Marksesteenweg 35 8500 Kortrijk Mob: +32 (0) 496162505 Email: info(a)cafe.be |