Skip to Content
0
Former Member
Mar 12, 2015 at 06:21 AM

Connection is busy with results for another command production order (OWOR)

186 Views

HI,

WHILE ADDING THE PRODUCTION ORDER...

I AM GETTING THE BELOW ERROR..

PLEASE HAVE A LOOK ON BELOW IMAGE..

To find the triggers:

---------------------------------------------------

SELECT T0.name 'trigger',

(select name from sysobjects T1 where T1.Id = T0.Parent_obj) 'table'

FROM sysobjects T0

WHERE type = 'TR'

To remove the triggers:

----------------------------------------------------

IF EXISTS (SELECT name FROM sysobjects

WHERE type = 'TR')

DROP TRIGGER tri_AddData_GRPO

DROP TRIGGER tri_AddData_Invoice

DROP TRIGGER tri_AddData_PORDER

GO

By using the above one i can able to resolve it... from sql

but i need to daily 10-15 times the above task..

may i know is there any Permanent solution...

For above problem...

I need your valuable suggestions...

Attachments

ErrorEEEEEEE.png (207.2 kB)