network profile
| bio | website | |
|---|---|---|
| location | UK | |
| age | ||
| visits | member for | 8 months |
| seen | Sep 14 '12 at 9:56 | |
| stats | profile views | 0 |
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? |
