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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2006-05-04 : 05:55:04
|
We've set up two linked servers (SRV1 and SRV2), one of them is in the local datacenter and the other is in some other place. The two servers are linked and everything seems to work fine...so far. Business Object Data Integrator (BODI) generates some code that runs on SRV1 but reads data off SRV2. Using profiler we have found that the following code is generated(dbo.GBN_FYLKE is a view on SRV1):set quoted_identifier onset implicit_transactions offset cursor_close_on_commit offset ansi_warnings onset ansi_padding onset ansi_nulls onset concat_null_yields_null onset language us_englishset dateformat mdyset datefirst 7set implicit_transactions on SET ARITHABORT ONIF @@TRANCOUNT > 0 COMMIT TRANSELECT "NUMMER", "NAVN", "REG_KODE"FROM "DBO"."GBN_FYLKE"... The problem is that the database doesn't return anything at all...it just hangs without giving any kind of recordset back. We've tried doing this in Query Analyzer and the same thing happens which is nothing. However; when we run this in query analyzer and set the implicit transactions to "off" everything works fine. The problem with this is that we can't change the BODI generated code. Have anyone experienced anything like this, or do you have any ingenious workarounds...? We have found the setting "Require distributed transactions for server-to-server communication" but we are not sure if this can do us any good, or cause us any problems.All insigths are welcome  --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
Implicit transactions and views on linked server