36 reputation
14
bio website
location
age
visits member for 2 years, 2 months
seen Mar 1 at 14:21

Jun
30
awarded  Notable Question
Jun
17
awarded  Popular Question
Sep
23
accepted Restrict update on certain columns. Only allow stored procedure to update those columns
Sep
23
awarded  Scholar
Sep
22
revised Restrict update on certain columns. Only allow stored procedure to update those columns
edited tags
Sep
22
comment Restrict update on certain columns. Only allow stored procedure to update those columns
Thanks Michal, but this solution won't work for me because, my application is a web application that is using connection pooling. All users connect using the same SQL Server Connection String.
Sep
22
comment Restrict update on certain columns. Only allow stored procedure to update those columns
That is a good point. But the problem remains unsolved without breaking a lot of applications that are using connection pooling.
Sep
22
awarded  Student
Sep
22
awarded  Editor
Sep
22
revised Restrict update on certain columns. Only allow stored procedure to update those columns
added 439 characters in body
Sep
22
asked Restrict update on certain columns. Only allow stored procedure to update those columns