Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ccorbalan
Starting Member
3 Posts |
 Posted - 2008-04-10 : 08:52:49
|
| Hello,I have 2 servers linked with SQL2000(SP4). I have developed an application that executes a stored procedure from server1. This stored procedure executes other procedures from server2. The store procedure from server2 executes updates / deletes / inserts to tables from a database server2.The problem is that sometimes, the process (spid) running on server2 still working and never finished. It seems like another process is blocking the tables it use but it is not true because I can do the same from SQL Analyzer. If I query the processes running on the server (sp_who, sp_lock, sysprocesses) it is OK and no ohter processes are running.Other times the execution works fine.Anybody can help me?Thank you |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 09:36:13
|
| Didn't get your question clearly? |
 |
|
|
ccorbalan
Starting Member
3 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 22:26:28
|
| Did you trace it in profiler to see what's going on there? |
|
|
|
|
|
|
Lock problem with linked servers