Great script. I noticed not all of my databases were showing under --> Database(s) Details <--. The join is using name and several of my databases have logical...

When would a duplicate foreign key be used?

udayroy15 (8/29/2012)

---

Sparse columns are a property of the storage layer, rather than the logical table. Therefore a SELECT…INTO statement does not copy over the sparse column property into a new...

dineshbabus (6/25/2012)

---

Hi Guys,

Can anyone explain how two rows will be inserted. I tried the same and for me only first record is getting inserted.

create table T1 (a int not null,b...

Here is a quick script to detach all Test_ databases in my instance. If you need to detach everything, use the commented line in the cursor. You can...

Hugo Kornelis (5/17/2012)

---

wdolby (5/17/2012)

---

I got this wrong thinking the entire batch would roll back. After playing around with it, now I know the transactions prior to the rollback will...

I got this wrong thinking the entire batch would roll back. After playing around with it, now I know the transactions prior to the rollback will still be committed...