I wouldn't bother with cascade here.

States usually don't go anywhere (too often).

And delete subjects shouldn't require you to delete a state.

The problem probably that you have a circular refference.

Delete a...

#1 I wouldn't bother with the identity here. Abbreviation is a correct PK.

#2 You need 1 FK for each column in the 2nd table.

I do that myself too often but skipping over those words is EXTREMELLY unwise.

I would suggest that you put that DB into restricted user mode and stop any apps that...

Wait, did you uninstall a MS feature or something from the vendor??

That changes who I'm sending the bug too!

P.S.

EM OR SSMS?

steveb. (10/26/2011)

---

Sounds very annoying..

As for telling the real vs fake nulls apart. The 'Real' null values should have a slight yellowish background to the gird cell when viewing...

I'd start another trace.

Add the rowcount column

Add the events SQLStmtCompleted AND SP:StmtCompleted.

Run both reports...

Why do you want to go down that route?

Post your issue on connect. It'll surely be looked at.

And it doesn't fail the same way for both reports?

Did you change the datasource for report #2?

Can you confirm this behavior by firing up profiler?

I've never heard that we can even edit the separator so I have nothing else to offer here.

GilaMonster (10/26/2011)

---

Ninja's_RGR'us (10/26/2011)

---

So you co-write the book and you still have to...

Is 1 parameter a free edit textbox and the other one a multi-value list?

GilaMonster (10/26/2011)

---

BrainDonor (10/26/2011)

---

GilaMonster (10/26/2011)

---

BrainDonor (10/26/2011)

---

No no no no no - if it doesn't make the bookshelf bend then it isn't worth buying. I haven't yet moved to ebooks (unless it's...

SPOOK.