No you cannot - why would you want to do this anyway ?!

You could create another table with an identity column and do a "select distinct..." into it...

Focus on the +ves...think of all the fertilization benefits...

You really do like that (very) handy Numbers table don't you...

..If you don't want to maintain a separate table and just want to...

oh I am so miffed -

It's all about timing could well apply to Jeopardy as well...I did not realize that everyone (at least...

Could you pl. provide some more information...

1) How many different values can be there in Col2 ?! What is the length ?!

2) Is it always comma separated and are the...

Like so...

SET IDENTITY_INSERT testscreen ON

INSERT INTO del_screen(col1, col2, col3, date....)

SELECT col1, col2, col3...getdate() FROM deleted

SET IDENTITY_INSERT testscreen OFF

..however, it seems that all you really want to do is insert your...

While Steve certainly has cause to be tickled GPF2^ needs some "check up from the neck up"...

ps:Then again I know that a lot of...

For the last time...

01000101-01101110-01100100

01101111-01100110

01100010-01110010-01100101-01100001-01101011-00100001

01000111-01101111-01110100

01110100-01101111

01110111-01101111-01110010-01101011-0011101000101000

Not that I know of...BOL does say "Many DBCC commands can produce output in tabular form...This information can be loaded into a table for further use" - but I don't...

01001001

01110011

01110100

01101000

01100101

01110010

01100101

01100001

01101110

01100101

01100011

01101000

01101111

01101000

01100101

01110010

01100101

00111111

..this can get to be pretty addictive..

Several things - all suggestions since I'm not really sure what the source of this error is -

1) You may want to check both EOF & BOF.

"Use EOF after using...

...and for all those that are on vacation and know this only because they log on to SSC in the evening instead of at the break of dawn...MY deepest sympathies...

see if this is what you need!

If I understand the question correctly then DBCC CHECKIDENT ('tblName') is what you're looking for...I needed to use this recently because I wanted to reseed a column.....