you try this query I think it should work

update TableA

Set TableA.OldEmail = TableB.NewEmail

from TableA join TableB on

TableA.LastName = TableB.LastName and

TableA.FirstName = TableB.FirstName

updation is nothing but deletion followed by insertion

so you execute select col1 from deleted in trigger then you will get old value

select col1 from inserted will give you new value

I think there is misunderstanding about the trigger

though trigger is a stored procedure you can not execute it manuallly. it gets executed when you try to do Insert or update...

What statement you have provided it seems that you want to create another table using results of existing table

for that you have to use select into command

in that case your...

DBCC SHRINKDATABASE('database',10,TRUNCATEONLY)

BACKUP LOG database WITH TRUNCATE_ONLY

You generate the script of Stored procedure. and execute this script using Query analyser on New Server. I think this is the best option.

It is possble if both server are on.

open package in design mode. go in package and use save as option. There you give new server name, username & password. hope...