128 reputation
4
bio website
location UK
age
visits member for 2 years
seen 2 hours ago

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


Sep
16
awarded  Commentator
Sep
16
comment Log full and an Active_transaction on database
@TheGameiswar Well looking at my query (which is contained in a Begin/Rollback) - Why would I end up with a full logfile and no rollback?
Sep
12
comment Log full and an Active_transaction on database
@Shanky - Is there not a way I can just terminate the transaction? Or can that only be done by someone with more privileges?
Sep
12
comment Log full and an Active_transaction on database
@Shanky Two rows - max_size 172800 and max_size 7168. MDF and LDF respectively. is_percent_growth = 0 for both
Sep
12
comment Log full and an Active_transaction on database
I can't do anything physically with the server - they are over the network in another city....
Sep
12
asked Log full and an Active_transaction on database
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?