Yes sorry I should have clarified. The initial execution of the external process via the trigger was to be a "fire once" operation that returned immediately and designed to ignore...

Thank you very much for your response.

Solomon Rutzky (11/23/2014)

---

Hi there. What do you consider to be "frequent" inserts? How many rows in this table already, and how many projected to...

Gedas (10/8/2010)

---

You can kill rollback only by doing that but you must have latest backup:

1. stop SQL engine

2. delete db and tlog files

3. start SQL engine

4. delete db

5. restore...

andrew gothard (2/12/2014)

---

Basically, if you see a fk which references two tables at the same time ... how does that work? It doesn't, if it's in one table it...

My only feedback is I'm a big fan of sticking to integer arithmetic where possible so a few neat tricks there!

Damnit! I went to vote 5 stars and the location of the 5th star changed so it hit 2?!? Can I change it?:unsure::blush:

Yes statistically low probability but rows *can* be returned if SYSDATETIME() and GETDATE() at a particular time are equal. The "correct" answer is not correct.

SanDroid (12/14/2012)

---

Eric M Russell (12/14/2012)

---

Database deployments have unique challenges like: altering or dropping/recreating schemas while preserving existing data, object dependencies, schema variations between development, QA, UAT, and production.

However, the...

Regarding Visio 2007:

Question: Does Visio 2007 support forward engineering of DDL?

Answer : No, Visio 2007 does not support forward engineering of DDL. Only, Visio for Enterprise Architects (VEA) supports forward...

I'm suddenly getting the same error too... figure the same (that it is a user/role permission issue) but it was working perfectly for 3-4 days.

I should clarify. The receiver...

"The private key is used to encrypt the data and the public key is used to decrypt the data."

Shouldn't it be the other way around?

Great article though!