<div>
Hey Brian<br />
<br />
I put in the select statement and it found all the records. &nbsp;I tried Truncate also and it still kept the records in there. &nbsp;Is there something in SQL management studio that could be disabling deletion?<br />
<br />
Thanks<br />
ANdy
</div>


<div>
Hello All<br />
<br />
OK here is a new twist which makes me think something is up with SQL Management Studio (but what do i know :D)<br />
<br />
I highlighted the last line in the stored procedure<br />
<br />
DELETE FROM [Export Plan Selection and Deduction To Send New EE]<br />
<br />
and ran just that, and it deleted the records.<br />
<br />
But when I tried running the whole stored procedure it did not work.<br />
<br />
Am I on to something?<br />
<br />
Andy
</div>


<div>
Is it possible we are dealing with different databases with identical tables and you are confusing the scope
</div>


<div>
I don't think so. &nbsp;This problem seemed to appear recently, plus when I ran the delete statement by itself it did delete the records. &nbsp;I am wondering if I should do a repair on SQL management studio?
</div>


<div>
There's not really much to repair. &nbsp;At this point I don't have any idea why your query is acting so strangely but I can almost guarantee you that it's not SSMS.
</div>


<div>
I could not get the others to work, and then I ran out of time. &nbsp;The workaround seems to be functioning so I wanted to thank everyone for their suggestions but for now I am going with the workaround
</div>


<div>
<div class="content wysiwyg-content">
OK I know this has to be easy but I know next to nothing about SQL. &nbsp;I thought I knew this but I just do not know.<br />
<br />
I have a stored procedure on our SQL server that is called from an Access frontend (I have attached the delete query).<br />
<br />
It really is super simple, but I am confused because what is happening is that nothing is deleting.<br />
<br />
I went onto the server, opened management studio, right clicked on the stored procedure (chose modify) and ran it. &nbsp;I got command successful, but when I opened the table it was supposed to delete all records out of, the records are still there.<br />
<br />
In fact when I run any of the delete queries in stored procedures (the same way as above) they do not delete records.<br />
<br />
I know the answer will make me feel stupid but I am ready to admit I am lost :D<br />
<br />
Thanks!<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/04_w15/1090735/problem.txt" target="_blank" class="file-inline" title="Very simple SQL Delete query not working. (342 bytes)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>problem.txt</a>
</div>
</div>


Very simple SQL Delete query not working.

problem.txt

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

Thanks!

SQL Stored Procedure for Delete not working

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.