SELECT TOP 1 b.last_lsn
FROM msdb..restorehistory a
	 INNER JOIN msdb..backupset b ON a.backup_set_id = b.backup_set_id 
WHERE a.destination_database_name = ?
ORDER BY restore_date DESC

DECLARE @numericlsn NUMERIC(25,0) = ?,
		@v_publication VARCHAR(255) = ?, 
		@v_subscriber VARCHAR(255) = ?,  
		@v_subscriberDB VARCHAR(255) = ?,  		
		@v_subscription_type NVARCHAR(4) = ?,
		@v_subscriptionlsn BINARY(10),
		@v_publisherdb VARCHAR(255) = ?
DECLARE @high4bytelsncomponent bigint,
        @mid4bytelsncomponent bigint,
	    @low2bytelsncomponent int
SELECT  @high4bytelsncomponent = convert(bigint, floor(@numericlsn / 1000000000000000))
SELECT  @numericlsn = @numericlsn - convert(numeric(25,0), @high4bytelsncomponent) * 1000000000000000
SELECT  @mid4bytelsncomponent = convert(bigint,floor(@numericlsn / 100000))
SELECT  @numericlsn = @numericlsn - convert(numeric(25,0), @mid4bytelsncomponent) * 100000
SELECT  @low2bytelsncomponent = convert(int, @numericlsn)
SELECT  @v_subscriptionlsn = CONVERT(binary(4), @high4bytelsncomponent) + convert(binary(4), @mid4bytelsncomponent) + CONVERT(binary(2), @low2bytelsncomponent)
EXEC sp_addsubscription
	@publication = @v_publication, 
	@subscriber = @v_subscriber,  
	@article = 'all',
	@destination_db = @v_subscriberDB,		
	@sync_type = 'initialize from lsn',
	@subscriptionlsn = @v_subscriptionlsn,
	@subscription_type = @v_subscription_type,	
	@update_mode = 'read only',
	@subscriber_type = 0;	

EXEC sp_addpushsubscription_agent 
	@publication = @v_publication, 
	@subscriber = @v_subscriber, 
	@subscriber_db = @v_subscriberDB, 
	@job_login = null, 
	@job_password = null, 
	@subscriber_security_mode = 1, 
	@frequency_type = 64, 
	@frequency_interval = 0, 
	@frequency_relative_interval = 0, 
	@frequency_recurrence_factor = 0, 
	@frequency_subday = 0, 
	@frequency_subday_interval = 0, 
	@active_start_time_of_day = 0, 
	@active_end_time_of_day = 235959, 
	@active_start_date = 20170703, 
	@active_end_date = 99991231, 
	@enabled_for_syncmgr = N'False', 
	@dts_package_location = N'Distributor';