I need to insert data into a table in DB2 from a similar table in DB1.  I
want to say

Insert Into tblx Select * from server1.DB1.dbo.tblx

tblx contains 40 columns which I would like to not have to list.  One of the
columns is an identity column.  Is there a way I can run this insert
statement without having to list all the columns?  Note:  tblx on DB2 is
empty, so is there a way I can tell it to let the Identity values from
DB1.tblx in?

Thanks,
Rich

Clustered Index Not Working
Select distinct problems
UPDATE varchar(max) column using INNER JOIN with SQL2005
Top 1 query problem
SELECT Query Quest... JOINING table, finding missing records