Hi - it's ASP.Net - where you add paramters to the SPROC using Parameters.Add...... - not by "select * from my table where " & somenastycode

So think that's all good...

Once again, thank you - I can understand the reasoning - and I suppose granting rights to insert/delete table data, opens you up to sql injection (something else I've been...

Thank you - I really appreciate it.

I will try to use SPs as much as possible, and I'll also look at setting up a role, to just be able to...

Hi Liam - perfect, thank you - for me a scenario was all that was missing!

Cheers, Mark

Hi - can I ask for a scenario for when this would be useful? I'm keen to learn.

As I see it, if I wanted a list of values -...