Stored Proc has stoped working

[VBXL]

All of my stored procedures have stopped working

It stops after i try and set a variable

i.e

set @examplea = @exampleb

It has always worked but before but has stopped working since i was trying to use COMMIT and TRANS statements. The statement works in the test database. Any ideas ??

 

[tlbroadbent]

You haven't provided enough info to enable us to help.

Do you get an error message? Can you show us the SQL code of the procedure? What version of SQL Server do you run? Is the procedure exactly the same on your test and production databases? Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm