USE tempdb;

GO

CREATE TABLE dbo.A (a INT NOT NULL);

CREATE TABLE dbo.B (b INT NOT NULL, c INT NOT NULL);

GO

INSERT dbo.A (a) VALUES (1);

INSERT dbo.B (b, c) VALUES (2, 3)

GO

CREATE...

rvasanth (4/7/2010)

---

If Table2.FieldId is foregin keyof table1.FieldId and if we have casecade delete between these two field, when we delete the FieldId '1' from table1 will automatically delete FieldId '1'...

rafa.aborges (4/7/2010)

---

Thanks, guys! Great advices!

Another question: Do you know if I might have issues to set the row level versioning on even if the compatibility level is set to 80...

vivek.yadav (4/7/2010)

---

Hi aplogize Paul...

Actually i didn't find the nxt page.

that's why i posted that...

But you are much faster then me.. i edited in 1 sec. and you...

David Fulton-420388 (4/7/2010)

---

Paul White NZ (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

I'm in the camp that the DBA should maintain the data entered by the users. If data looks incorrect, then bring it...

Wow he is...

george sibbald (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

I'm in the camp that the DBA should maintain the data entered by the users. If data looks incorrect, then bring it to the users'...

Thank you very much! :blush:

I will consider that.

@dave-3: Absolutely right!...

Paul White NZ (4/7/2010)

---

You just want to list the foreign key relationships then, not just the primary keys? Do you want to include foreign keys that reference a unique...

No worries. Don't forget to check XACT_STATE in the CATCH block 🙂

That's what he said. Your post claimed it returned 1. ...

Chris Howarth-536003 (4/7/2010)

---

If this is the only reason that you are looking to rework the code then I would consider turning off the default trace, scripting it, amending the script...

LOL :hehe:

I like guessing games 🙂

My...

I know - mine is just...