128 reputation
3
bio website
location UK
age
visits member for 1 year, 7 months
seen Sep 14 '12 at 9:56

I build websites and desktop apps for a faceless multinational behemoth. I sometimes find myself trying to get Excel to do things.


Sep
13
awarded  Scholar
Sep
13
accepted Will a SP which writes records fail if accessed by a db_datareader role?
Sep
13
awarded  Student
Sep
13
comment Will a SP which writes records fail if accessed by a db_datareader role?
Yes I'm writing before and after. So I insert a new row at the top and then update that row at the end (with the time). Only my writes are working, even when I connect with the logon the remote app is using. All other writes are apparently failing. I think I need profiler!
Sep
13
comment Will a SP which writes records fail if accessed by a db_datareader role?
I'm kind of working in the blind. I have an ID IDENTITY(1,1) on the log table and when I insert a row the ID will have jumped - but I can't tell why. I can only assume it is a failed INSERT from when the remote app has executed the proc.
Sep
13
comment Will a SP which writes records fail if accessed by a db_datareader role?
Good suggestion but I don't think I can open profiler :( Can you think of any reason why connecting from Java or .Net would make any difference - bearing in mind that both connections actually work and can hit the proc?
Sep
13
comment Will a SP which writes records fail if accessed by a db_datareader role?
I don't want the proc to actually fail as the remote app is a live system
Sep
13
awarded  Supporter
Sep
13
comment Will a SP which writes records fail if accessed by a db_datareader role?
I can put a TRY CATCH on but I can't see what the error is as I don't appear to be able to write to my log-table! I have quite limited access to the server itself.
Sep
13
comment Will a SP which writes records fail if accessed by a db_datareader role?
Hmm yeah that's what I thought. So I can't figure out why there seem to be these failed INSERTs going on...
Sep
13
asked Will a SP which writes records fail if accessed by a db_datareader role?