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