Connection Timeout Linked Server
Posted
by
Wade73
on Stack Overflow
See other posts from Stack Overflow
or by Wade73
Published on 2011-01-04T19:00:02Z
Indexed on
2011/01/06
4:54 UTC
Read the original article
Hit count: 179
sql-server-2005
|asp-classic
I have created a linked server from one SQL Server 2005 to Another 2005. When I run an update query through the SQL Server Management Studio (SSMS), it runs in under a second. If I run the query through a asp webpage it times out. I ran SQL Profiler to see if I noticed anything as well as the Activity Monitor in SSMS and all I found was that a lock was being created (Wait type LOCK_M_U), but I can't find what is locking it. Any help would be appreciated.
Wade
© Stack Overflow or respective owner