I am trying to do an update on a linked server, which is a development server. I get this error everytime. when I remove the update code everything...
HI, I have found myself with the same problem. need to upload and retrieve binary data from sql server, using asp. if anyone knows of a web site...
Ok, I have set up a trigger that calls a stored procedure which appends to a file, here the the stored procedure I found...
I tried the trace when we first started experiencing the problem. but could not catch the roll back issue, it happens very infrequently, maybe once...
Everyone, I think I have found a solution, I am working on it now. I found a procedure that will append to a file, I will call this procedure from...
qaurav, before trying to use a job and since I don't see how I will deliver parameters to a job, I wanted to try using a trigger to write the record...
gaurav, Great Idea, I will try that. Wolffy.
Gaurav, I am not sure I know what you mean. I have the trigger on the payment table that I want to log, a stored procedure inserts into this payment...
gaurav, No that does not sound weird, and I thought about it. but I will need to write a page that will do a search on this log table. And I should...
I have a problem where a third party written group of procedures are doing a rollback for some reason, and wipping out the records that were inserted...
sP 3 , I tried experimenting on other databases and found some of them will not shrink the log file at all unless I change the options to simple...
royv, Thanks for the help. I am found that switching to simple recovery and back to full accomplishes almost the same results as detaching, and...
I can not set DB only since this is a 7,24 box. But I thought you didn't have to just to shrink the database, tranlog, or their physical file size....
Hi everyone, I have had this problem only a few times in my 7 years as a DBA. I notice that the transaction log file grew to a large amount usually...
Cesar, I found this to be the best approch to this kind of Problem. I keep the index field the way it is, add another column called "sequence" make...
I have had this problem before. Adding more RAM and more swap drive fixed it for me. But I did have errors in the event logs pointing me in that...
Separate names with a comma.
