views:

14

answers:

0

Hi

I want to wrap data operations involving 2 dbs one of which is an SBA db using the SBAAPI. Several problems arise: 1. The API insists on the transaction Isolation level being Snapshot. Any other level gives and error. 2. When I use Snapshot level, I get an error "SQL Server does not exist, the service is stopped, or access is denied". Inner exception shows "Snapshot Transaction cannot be promoted"

Any idea how to go about this?

Onesmus