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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Forcing isolation level

Author  Topic 

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2008-11-14 : 11:46:35
Is it possible to force a certain isolation level for a user or a host?

We have this Siebel Analytic tool used by the business that is placing locks on the replica, after speaking with the Siebel guys they say they can't change the code otherwise Oracle won't support the product anymore. I've looked at the code and it's terrible, we are trying to find a solution for this. Either we force isolation for the user that this tool uses or we'll have to create another replica just for Siebel, which won't really solve the problem.

Any suggestions?


---
http://www.ssisdude.blogspot.com/
   

- Advertisement -