No apology from me - I gave my best answer based on the question asked, before considering the relative merits of the carpet-ation-ization of a warehouse.

Carpeted soles seem a practical...

2Tall (3/10/2010)

---

Paul great stuff. I will add in the remaining 65 columns :). If I add all additional columns from the table to which sections of your code must...

Wesley Norton (3/10/2010)

---

If I understand data types correctly (that's a huge assumption) then it doesn't really matter what the length is set to, nvarchar(max) would be exactly the same size...

Zzzzzzzzzzzzzzzzzz

:w00t:

Lynn Pettis (3/10/2010)

---

Actually, the last 10 minutes or so of the game was quite exciting compared to the first 70 minutes. It took that save on the PK to...

Yes, that is what I meant to...

Lynn Pettis (3/10/2010)

---

Paul White (3/10/2010)

---

C'mon guys, think outside of the box! Ok, so...

Maybe that too, though the...

C'mon guys, think outside of the box! Ok, so warehouses aren't usually carpeted,...

When I get my next data warehouse, I'm gonna carpet it :w00t:

Mmm, nice warm floors...

The confusion probably arose because you can RESTORE to a snapshot. You're right though - it isn't a backup.

To the OP:

Database snapshots...

It was covered by the "IIRC", so no need to :blush:

Yes if it is self-contained. No if you are thinking of replicating from a production system.

Roy Ernest (3/10/2010)

---

Steve Jones - Editor (3/10/2010)

---

That's like saying should we use carpet in a building. There's no way to answer that unless someone knows what you are trying to...

Mh-397891 (3/10/2010)

---

How do I identify the primary key in both the tables, as I will be making a script to check if primary key in the first table is present...