|
|
Posted by Hugo Kornelis on 09/25/06 22:46
On 25 Sep 2006 03:04:37 -0700, nano2k wrote:
>Hi
>
>Shortly, I keep invoices in a table.
>Occasionally, someone will fire the execution of a stored procedure
>(SP) that performs several UPDATEs against (potentially) all invoices
>OLDER than a date that is supplied to the SP as a parameter.
>The SP is usually a lengthy process (it takes at least 30 mins).
>The problem is that SQL server 2000 Dev Edition doesn't allow me to
>insert new invoices that are "younger", while the SP is executing.
>How should I specify to SQL Server that new invoices are "harmless"?
>
>Thanks.
Hi nano2k,
To answer that question, we need to know:
- The design of your tables. Please post in the form of CREATE TABLE
statements. Don't forget to include all constraints and properties and
all indexes for the tables - they are probably a key factor in this
situation.
- The code executed in the stored procedure.
- The code executed to insert new rows.
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|