See: http://support.microsoft.com/kb/224071

James.

Just thought I would check, you do know that only one table can have the IDENTITY_INSERT option set to ON during any given users session don't you?

Also if you disconnect...

Oops!  I made the same mistake as Jeff in his post.  I got distracted by trying to find how to identify the identity columns and did not follow through on...

I thought this an interesting enough problem that I went and searched for an answer and found a post by Jeff Moden at http://p2p.wrox.com/topic.asp?TOPIC_ID=52760 that accomplishes what you want:

SELECT so.Name...

Ok, I have got to know, why would you want to, or need to?  Just curious what circumstances would prompt this necessity.

James.

I've looked through your previous posts and your questions are all over the place, but some appear to be more than typical homework and could be problems encountered at work,...

--Assuming you have "inventory tables similiar to the following:

--(you should post DDL for all tables involved when looking for this type of help)

declare @invItems_ table (itemNo_ int, itemName_ varchar(20))

declare...

Here is a quick example that I have tested using a "datename" table.  You would of course want to add keys, indexes, etc to the table, but, well you get...

The easiest way is with "datepart" and a case statement, as in the following:

select

(case datepart(dw