How can we help you today? How can we help you today?

Tried to delete stored procedure and commit changes, but got the following error:

Hi,
I tried to delete a stored procedure and commit changes, but got the following error:
"PendDelete returned an unexpected number of files"
How can I fix it?
Does another why of deleting a stored procedure exist?

Thank
yshildan
0

Comments

2 comments

Sort by
  • Eddie D
    Hi, thank you for your support request.

    Where exactly are you deleting the Stored Procedure? Are you editing the source control repository directly? Or running a DROP PROCEDURE query in SSMS?

    SQL Source Control creates a log file in this path:
    C:\Users\<user name>\AppData\Local\Red Gate\Logs\SQL Source Control

    Is there any entry in the log file that may explain why the reported problem is occurring?

    Many Thanks
    Eddie

    Eddie D
    0
  • yshildan
    Hi,

    I deleted the PROCEDURE on my workspace by right clicking it and choosing delete. It worked fine, but the problem occurred when I tried to commit changes.
    I tried deleting it with DROP but the same problem occured

    The log file says that the PROCEDURE I want to delete is not found on my workspace

    Thanks for your response,
    Yuval
    yshildan
    0

Add comment

Please sign in to leave a comment.