You should write only one SP and check for this condition before deleting. Set proper isolation level in your sp and sql server should be able to handle your concurrency...

different processes that are created from your multithreaded application are...

Not sure, there could be something else he is missing out or if there are any client side settings that is preventing. I could write it outside the stored procedure...

HowardW (9/23/2009)

---

Technically, a bit value of 1 is true as if you print the variable, you'll see 66 has implicitly converted to 1.

Good idea for a QOTD, I wouldn't have...

Narendra-587652 (9/22/2009)

---

thank's to all for your valuable suggestion.

but still the problem is same .

as it due to domain access it not solving my problem .

is three any way by...

May be that stored proc does not exist in the database context that you are executing this job in?

You got your solution? its very straightforward you should be able to do that. If not just give the table structure.

cindy.hutchins (9/18/2009)

---

These are all very helpful. However what happened was parts were being removed from a component electronically. Each part was removed once, this will store automatically in...

Can you provide some test data please?

Add to the above suggestion, I think I just saw one more discussion related to the duplicate entries just today,

http://www.sqlservercentral.com/Forums/Topic790009-338-1.aspx

I think you can pass, something like this..

Select '''' + convert(varchar(10),group_id), * from Group_Test

But I think it can also be handled while writing it onto the...

AS per BOL,

CREATE FUNCTION [ owner_name. ] function_name

( [ { @parameter_name [AS] scalar_parameter_data_type [ = default ] } [ ,...n ] ] )

RETURNS...

CREATE TRIGGER prevent_delete ON yourtablecolumn INSTEAD OF DELETE

AS

BEGIN

RAISERROR ('')

END

GO

instead of trigger will do?

ohh sorry, now I realize it should've been jobtitle instead of jobid