Avatar of alevin16
Flag for United States of America

asked on 

SQL Stored Procedure for Delete not working

OK I know this has to be easy but I know next to nothing about SQL.  I thought I knew this but I just do not know.

I have a stored procedure on our SQL server that is called from an Access frontend (I have attached the delete query).

It really is super simple, but I am confused because what is happening is that nothing is deleting.

I went onto the server, opened management studio, right clicked on the stored procedure (chose modify) and ran it.  I got command successful, but when I opened the table it was supposed to delete all records out of, the records are still there.

In fact when I run any of the delete queries in stored procedures (the same way as above) they do not delete records.

I know the answer will make me feel stupid but I am ready to admit I am lost :D

Microsoft SQL ServerMicrosoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon