Up! Tried both InternalTransaction and ExternalTransaction for it... InternalTransaction - helps. connections is same.
ExternalTransaction - not. Connection ID is changed.... :/ Evgeny. 12 января 2010 г. 11:08 пользователь Рябицкий Евгений <[email protected]> написал: > Hello 2 everyone! > > > > I have one potential problem: > > > > We have stored procedure on MS SQL Server. It's doing some job and return > result in special table marked with connection id (@@SPID). > > > > So next query is to get result: SELECT * FROM SpecTable WHERE spid = @@SPID > > > > So these 2 queries should be in same connection (to have same @@SPID). > > > > In first solution there was huge transaction wrapping around this 2 queries > and I think there was same connection. > > But for performance proposes I can't use one huge transaction, so I switched > to explicit transaction (to not have any transaction). > > Now I am not sure how to make sure that these queries are performed in same > connections??? > > > > Evgeny. > > > >
