Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

COM+ Question

2 Posts 2 Posters 0 Views 1 Watching

V Offline
V Offline
voonna

wrote on last edited by

#1

I have a COM+ component which bulk inserts records into a table, which takes 5secs to process one request. If I try executing this component multiple times while it is processing job. SQL server 2000 throws PRIMARY KEY VIOLATION error. How can I lock that table while the component is in process. Thanks a million
E 1 Reply Last reply

0
V voonna

I have a COM+ component which bulk inserts records into a table, which takes 5secs to process one request. If I try executing this component multiple times while it is processing job. SQL server 2000 throws PRIMARY KEY VIOLATION error. How can I lock that table while the component is in process. Thanks a million
E Offline
E Offline
Erik Juhl

wrote on last edited by

#2

Did you configure the component to require new transaction?
1 Reply Last reply

0

Log in to reply