Execute an update stored procedure

  • Thread starter Thread starter chris locke
  • Start date Start date
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?
 
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
 
Back
Top