We have an sp which runs AOK in Query Analyser yet when its ran via
ColdFusion it crashes it - and I mean a total reboot.

I will provide some pseudo code first to see if anyone has had this
problem..

---------------------------
BEGIN TRANSACTION
        INSERT INTO 
           SELECT 

DELETE FROM

SELECT @@IDENTITY

COMMIT

SELECT WHERE @@IDENTITY



The last SELECT seems to be causing the problem as when you remove it from
the SP it works AOK....but when its in it freak la sheek's?

Wierd non?

If you need code, let me know and I will post it on.



-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to