Viewing 15 posts - 42,286 through 42,300 (of 49,566 total)
r.hensbergen (12/18/2008)
Oh no, my ancestors went to your country and.... We're family! 😉
Hehehe :hehe:
Actually I'm originally from the UK, so you don't have to worry. :w00t:
December 18, 2008 at 11:00 am
srawant (12/18/2008)
Gail will If I turn on that flag will it show me the graph of the past like it was occurred yesterday...
No. It will print the deadlock graph...
December 18, 2008 at 10:38 am
Steve Jones - Editor (12/18/2008)
Well, this is officially the longest thread on the site.
We win! :hehe:
r.hensbergen (12/18/2008)
December 18, 2008 at 10:36 am
You posted the second question only 3 hours ago (and the 1st question only 12 hours ago). This isn't a chat room. Be patient. If you need help urgently, contact...
December 18, 2008 at 10:17 am
You can enable traceflag 1222 (DBCC TRACEON (1222,-1)) to get the full deadlock graph written into the error log. That will tell you what the other process was.
As for the...
December 18, 2008 at 10:14 am
Ok.
Is there a question?
December 18, 2008 at 8:32 am
Chris Morris (12/18/2008)
.. the global temp table is available outside the scope of the dynamic sql.
Ah. I thought that the end of the dynamic SQL would mean that the last...
December 18, 2008 at 8:12 am
Jeff Moden (12/18/2008)
It's bad enough that we now have two national languages
Only 2? Be grateful, I've got 11. Only two of those are due to immigration (and both...
December 18, 2008 at 7:54 am
Ok, so you're implementing application load balancing, completely outside of SQL and DB mirroring for high availability.
What's the question then? I think I've missed something.
December 18, 2008 at 7:24 am
It'll be recorded in the default trace. There are 5 (or so) trace files in the SQL error log directory, that's the default trace (providing you haven't turned it off)
The...
December 18, 2008 at 7:12 am
clementhuge (12/18/2008)
However, by load balancing with several servers and let the round-robin clustering done by the application, I should achive load balancing, no?
How are you replicating the changes from one...
December 18, 2008 at 7:09 am
Grant Fritchey (12/18/2008)
I mean, did you ever see this before:
I have.
Great. Something else to worry about.
Not anymore.
Also, from that KB that you posted
Note In SQL Server 2005 Service Pack 3...
December 18, 2008 at 7:02 am
clementhuge (12/18/2008)
I would like to develop a high availability strategy for a company (both automatic failover and load balancing)
If I well understood clustering, it allows you to have n nodes...
December 18, 2008 at 6:50 am
Jack Corbett (12/18/2008)
The answer is "Yes"
I thought it was 42.
Tramp, can you state your question a little more clearly please? The question title gets cut off.
December 18, 2008 at 6:46 am
Grant Fritchey (12/18/2008)
From where I sit, there's still a bit more to learn here.
I think this is one of the areas of the internals where the more info you...
December 18, 2008 at 6:34 am
Viewing 15 posts - 42,286 through 42,300 (of 49,566 total)