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

yshildan

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

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

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