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 |
|
luciano costa
Starting Member
1 Post |
 Posted - 2007-03-09 : 06:55:19
|
Hey all,I've been experiencing an issue related to linked server. Here is the scene:- Application A queries View V located in SQL Server S1- View V accesses Table T located in SQL Server S2 using a linked serverThe problem is:- Application A start the transaction and it simply gets locked. It throws no errors nor exceptions.Important: - S1 and S2 are in different machines- When S1 = S2, then the application successfully access View V.Any suggestions? |
|
|
singh_anil74
Starting Member
1 Post |
Posted - 2009-09-14 : 17:50:01
|
| What is the isolation level of the transaction?-Anil Singh @ accent for future |
 |
|
|
|
|
|
Linked Server transaction locks...