Execute an update stored procedure

C

chris locke

This may be more of a pure SQL issue. I created a stored
procedure using the SQL Wizard to update several fields
in a table. When I run the SP, it does not return any
errors, but it does not work. I have looked at security
on both the SP and the table and it seems right, besides,
I am DB admin anyway, so I should be able to do what I
want.

Any ideas why this would not be working?
 
V

Vadim Rapp

cl> This may be more of a pure SQL issue. I created a
cl> stored procedure using the SQL Wizard to update
cl> several fields in a table. When I run the SP, it
cl> does not return any errors, but it does not work.
cl> I have looked at security on both the SP and the
cl> table and it seems right, besides, I am DB admin
cl> anyway, so I should be able to do what I want.

cl> Any ideas why this would not be working?

did you check what's going on with Profiler?

Vadim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access can't find stored procedure after scripting on sql server 2
the procedure executed successfully but did not return records 5
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
The stored procedure executed successfully but did not return any records 4
Execute a stored procedure asynchronously 2
Stored procedure as row source for a combo box 4
The stored procedure executed successfully but did not return anyrecords 1
ADP Update Query does NOT update ! 3

Top