Linked Server problem

[Reis, Tom]

Wh have a linked server defined between two SQL 2005 SP3 64bit servers.
When running a program we get the following error "OLE DB provider SQNCLI
for linked server "SSDEV" returned message "Cannot start more transactions
on this session". Is there a setting to increase the number of transactions
for this? I can not seem to find it.

[Erland Sommarskog]

I'm afraid that there is no setting today either, and I'm afraid that I
don't know more about this message today than I did yesterday over in
.server.

When you don't get a good answer for you initial post, it may be an idea
to provide more information. For instance, what is the context where you
get this error.

I would guess that you are trying to nested distributed transactions
or something equally complex.

A good question is: do you really want to do this, or are you doing this
because of a bug in your code?

If it is your code, and not something you experience with a third-party
program.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx