ALTER PROCEDURE [dbo].[proc_Marketing_RecordVehicleUpdate] 
	@VIN NVARCHAR(17),
	@OLD_DEALER_NAME NVARCHAR(50),
	@NEW_DEALER_NAME NVARCHAR(50),
	@OLD_DATE DATETIME
WITH EXECUTE AS 'DOMAIN\UserName-n'
AS
BEGIN

	--SELECT @VIN AS MY_COL
	INSERT INTO SWP.dbo.Marketing_ChangeDealerLog
				   (VIN, OldDealerCode, NewDealerCode, OldDate, NewDate)
	VALUES (@VIN, @OLD_DEALER_NAME, @NEW_DEALER_NAME, @OLD_DATE, GETDATE())
	

END