Viewing 15 posts - 1 through 15 (of 26 total)
we will check into that too, thank you very much...
April 2, 2012 at 1:47 pm
Craig, I really appreciate the time you took on this problem, your insights and those of others helped us narrow thus bugger down...
April 2, 2012 at 1:07 pm
Thank you, we will do that...
April 2, 2012 at 12:37 pm
Thank you, we will check it out...
April 2, 2012 at 12:02 pm
What is your suggestion to fixing the SELECT @@IDENTITY that we are using?
Ok, well, we rolled out the following change in our webservices and so far it is looking good...
April 2, 2012 at 11:54 am
We might have stumbled onto something - found some suspicious transaction definition in our web service declarations. We will try something different on Monday morning and if it works...
March 31, 2012 at 8:10 am
All tables are in the same database.
Just ran CHECKDB and all is fine.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'TDS'.
DBCC execution completed. If DBCC printed error...
March 30, 2012 at 3:13 pm
Ok, we captured both the failed and the immediately following successful insert statements and rediously compared each field and each value and the two are absolutely identical.
Since last post we...
March 30, 2012 at 10:50 am
Thank you Craig - the thing that is really bizarre is that there are instances where our software tells the user that save failed and to save again - the...
March 28, 2012 at 5:05 pm
I would be surprised that NULLs are a problem but we will see that in our trace of the INSERT statement that results in missing record. Yes, "O'Brien" is...
March 28, 2012 at 4:41 pm
Craig, thank you very much. You gave us a ton of stuff to chew on. The script of the table is below. One thing we did...
March 28, 2012 at 4:18 pm
Yes, we were planning on implementing those as well but the other one is much easier and is actually tied directly to the issue we are having - that is...
March 28, 2012 at 3:45 pm
Well, we know the insert has failed because we go to read the just inserted record and it is NOT there and we have an IDENTITY hole in the table....
March 28, 2012 at 3:32 pm
We will print out the insert statement in the case where the insert fails and we prompt the operator to save again (we still are inside our code and can...
March 28, 2012 at 3:20 pm
That is a good question, will have to ask the developers...
March 28, 2012 at 2:22 pm
Viewing 15 posts - 1 through 15 (of 26 total)