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

yshildanyshildan Posts: 2 New member
in SQL Source Control
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
Tagged:
· Share on Twitter

Answers

  • Eddie DEddie D Posts: 1,806 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • yshildanyshildan Posts: 2 New member
    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
    · Share on Twitter
Sign In or Register to comment.