Post reply

-6 return value

  • October 12, 2009 at 1:04 pm

    #138760

    I have a stored procedure that executes and does some data warehousing tasks. It used to work fine, but recently it's stopped updating, even though it executes fine. However, when I execute it it generates a return value of -6 (using the defualt exec script genenrates from ssms), and it's not set up to return specific values. Does anyone know what might be causing this?

  • October 12, 2009 at 1:12 pm

    #1064906

    Well i figured it out. The stored procedure had a try-catch and transaction set up in it, so the errors we're reporting like they normally would. i copied the sp and removed them and i get a slew of errors. fixed them and now it's happy again. For now. 😀

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply