Post reply

SP_Rename

  • October 11, 2001 at 10:46 am

    #77906

    Running sp_rename, we are inserting @@error. When the procedure fails it does not provide the error number, instead it provides 0. Running a different SP with @@error produces the right results. Is anyone aware of problems when using sp_rename with @@error?

  • October 11, 2001 at 4:16 pm

    #418866

    Not aware of any issues. You might try looking at the source for sp_rename, either stepping through the debugger or make a copy and modify the source with print statements so you can follow execution, see why it returns what.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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