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 |
|
Antonio Broughton
Starting Member
6 Posts |
 Posted - 2002-05-07 : 18:08:32
|
| Hi, I am wanting to know if it is possible to get access to a Linked Server inside a Trigger?I am wanting to (in MS SQL Server 2000), add a trigger to a table, that updates a field on a Linked Servers table.When I code this trigger, I get the error:Could not start a transaction for OLE DB provider '....'.Is there any way around this, or any other method in which I should be doing this?ThankyouAntonio Broughton |
|
|
indram
Starting Member
6 Posts |
Posted - 2002-05-07 : 21:05:34
|
| It is possible to do that. However, it depends on the OLEDB Provider. The provider must support nested transaction. As far as I know, the only provider that supports nested transaction is the provider for MS SQL Server itself. I've checked these providers and they don't support nested transaction:-Oracle Provider for OLEDB (came with Oracle 8.x installation)-MS OLEDB Provider for Oracle-MS Jet 4.0 OLEDB Provider-MS OLEDB Provider for ODBC.You might want to try the others. |
 |
|
|
|
|
|
Linked Server inside Trigger