TheAccidentalDBA (8/27/2014)

---

SSC-Addicted nice points and links. I posted two responses separately.Yes, totally agree on your points that its needs to be tested with restore. Logically, the following might work.

1. Only...

TheAccidentalDBA (8/27/2014)

---

When a snapshot is taken on a server, the drives needs to be quiesced for a very neglible time. Even this little time affects databases. So, an application aware...

also check sp_describe_first_result_set, thanks to Eirikur Eiriksson for heads up on that one!

http://www.sqlservercentral.com/Forums/FindPost1573301.aspx

Go read the wikipedia article on EDI.

http://en.wikipedia.org/wiki/Electronic_data_interchange

This will give you the key words to use when asking for information. Its sort of like a csv file, sure you can...

Jeff Moden (8/25/2014)

---

patrickmcginnis59 10839 (8/21/2014)

---

CELKO (8/21/2014)

---

This is one of those places where a loop (please see the solution I posted above) actually does work quite well and it's self...

CELKO (8/21/2014)

---

This is one of those places where a loop (please see the solution I posted above) actually does work quite well and it's self correcting based on the...

Would be interesting to see if you can recreate...

I was unable to left join without a predicate, even if the predicate was a dummy (1=1).

What version of SQL are you using?

I really don't know the answer, just responding to an interesting question, and hoping to see more comments.

I found this figure: Maximum User connections: 32,767

http://msdn.microsoft.com/en-us/library/ms143432.aspx

So if you're actually trying to...

dwilliscp (8/14/2014)

---

patrickmcginnis59 10839 (8/11/2014)

---

Looks like a "create table" inside an uncommitted transaction would do it. You might shop around for a better blocking script.

edit: reran your script, I'm a...

<nitpick>MSDE</nitpick>

MSDTC is the transaction manager isn't it? Just being picky about an otherwise...

K. Brian Kelley (8/12/2014)

---

venoym (8/12/2014)

---

K. Brian Kelley (8/11/2014)

---

venoym (8/11/2014)

---

I have to question the "myth" of the Air-Gap that is referenced. A proper Air-Gap or Data Diode for SCADA systems...

Looks like a "create table" inside an uncommitted transaction would do it. You might shop around for a better blocking script.

edit: reran your script, I'm a bit undecided on...

Gary Varga (8/11/2014)

---

patrickmcginnis59 10839 (8/11/2014)

---

GilaMonster (8/11/2014)

---

I have a friend who is of the opinion that it is impossible for his accounts to be hacked. Not unlikely, not difficult. Flat out...

GilaMonster (8/11/2014)

---

I have a friend who is of the opinion that it is impossible for his accounts to be hacked. Not unlikely, not difficult. Flat out impossible. He also says...