Dave62 (11/30/2012)

---

I got this question right after about 5 seconds or less of thought. My reasoning was that if you have to set something (like NULL Foreign keys or cascading...

What a terrible question and horribly wrong answer.

Actually, if it had said it was about SQL Server 6.5 it might have been alright; I don't think it it...

Banana-823045 (11/29/2012)

---

Tom, if it's a client setting, then that'd mean configuring all clients that runs the front-end software. Wouldn't it also potentially mess with other softwares? I'd prefer that it...

I carelessly said "On the server,...

Good question. It was nice to see anther one about this new feature.

None whatsoever, but I do know what error...

I may be barking up the wrong tree here, but maybe you are running out of sockets? That's what TCP Error 10048 means, and I think that's probably what...

seankyleprice (11/28/2012)

---

I believe I maybe have an answer as to why the behaviour of SET QUOTED_IDENTIFIER ON is different to the other set options, namely that the statement is issued...

Z machine

sark

Interesting question.

Quite bizarre.

My first reaction was "this is a trick, so 0 will be wrong and so will 9". But maybe it wasn't meant as a trick, but a...

Revenant (11/27/2012)

---

Koen Verbeeck (11/27/2012)

---

Revenant (11/27/2012)

---

Sorry, this...

Camus

En de broekzakken, I guess, in...

Jeff Moden (11/24/2012)

---

opc.three (11/24/2012)

---

However the OP is talking about producing their own function to generate sequential GUIDs that would not be affected by a restart. The tradeoff of course is...