I think altering the table and adding a constraint with NO CHECK option is what you need.

ALTER TABLE tblTable WITH NO CHECK ADD CONSTRAINT uqConstraint UNIQUE

Regards,

Sony Antony.

Try

CREATE DEFAULT for each column

As far as I know, convert is not necessary if you use date in the following format

yyyy-mm-dd hh:mm:ss.mls

Try giving date in this format

2008-12-29 00:00:00.000

I Think this will solve your...

Each feature in every gadget is present in it, because (atleast) somebody wants it to be there in it.

Now, if YOU don't want it, don't use it. That's all.

After...