Hi
Here's what I want to do:
I'm trying to update one table from another in SQL Server 2005. The two
databases that resides on the same server.

I want to make sure that the data in TableB is allways up to date with the
data from TableA.
So I want to :
1. Update existing rows in Table B with data from Table A
2. Insert any new rows from Table A into Table B. In this process i need to
run a stored procedure to retrieve a unique ID for Table B

This is easy in SQL Server 2000 but in SQL Server 2005 I just don't know
where to start !!
Help !! :-)

Peter