Viewing 15 posts - 1 through 15 (of 205 total)
Query now looks like this and it does what I want - but it may not be the best solution it is one that will get me going forward
...
November 20, 2013 at 4:14 pm
OK, running that script didn't reveal anything so I'll have a look at creating a trace that might trap the errors.
August 8, 2011 at 6:43 pm
I wish, but all we have is
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer...
August 1, 2011 at 8:11 am
I do believe that is a similar face to mine once I was told this was happening ...
August 1, 2011 at 8:02 am
There are no hints in the DB queries and we do not suggest how the lock should be - basically we trust SQL Server
August 1, 2011 at 7:58 am
I agree.
Very weird
The fact that the connection happens and data is retrieved, THEN the connection is lost ???
We have other environments where this utility is running without any issue whatsoever.
One...
August 1, 2011 at 7:52 am
Ninja's_RGR'us (8/1/2011)
Are those users connected on a db with log-shipping?
No
Do you kill connection to resolve blocking?
No
Do you reboot the server (or service) on a regular basis?
No
If I can work my...
August 1, 2011 at 7:35 am
No reason not to have both flexible and strong code in place to support the changing needs. If you've done enough investigation at the start of the process you will...
May 3, 2010 at 5:05 pm
So, if I have this clear in my head, if I have a query that joins several tables and and I'm selecting columns from a few of those tables, I...
March 11, 2010 at 5:53 pm
I like the idea of being able to spend time to make the process smoother, or the stored procedure go faster, or the code more readable and maintainable and flexible.
BUT...
April 23, 2007 at 3:27 pm
"The great ones seem to be able to look at a process and see the logical flow, how the data fits together, and how to make something functional out of...
April 19, 2007 at 6:15 pm
I think you have to be careful as to how you define a great programmer. I know people who can put amazing pieces of code together and get the code...
April 18, 2007 at 11:07 pm
IT will never fade away. There is too much under the hood that is complicated to allow automation to take over. There will always be a need for someone with...
April 15, 2007 at 6:06 pm
You said it : "get a job doing something you enjoy."
IT is not my passion but I am happy doing the job - most of the time.
I can't think of...
April 12, 2007 at 10:34 pm
An explanation of how (not why) this is happening.
In my database there is a parent child relationship defined.
The child table is the one getting the conflicts.
The conflicts occur...
April 3, 2007 at 2:33 pm
Viewing 15 posts - 1 through 15 (of 205 total)