Hi Steveb..

Can you explain briefly ont this,I am posting my procedure

ALTER PROCEDURE GetLastLSN

(

@TableName NVARCHAR(100),

@LastLSN BINARY(10) = NULL OUTPUT

)

AS

BEGIN

/*****************************************************************************************************************

Gets the last LSN that was parsed during the last run for a given table.

When used to run the job again increment the last LSN by 1 so that we are actually not parsing duplicate rows.

If last LSN returned is 0x00000000000000000000, use "sys.fn_cdc_get_min_lsn" to get the minimum LSN to use.

*****************************************************************************************************************/

DECLARE @_LastLSN BINARY(10)

SET @_LastLSN = 0x00000000000000000000

SELECT @_LastLSN = LastLSN FROM LSNLog WHERE TableName = @TableName

SET @LastLSN = @_LastLSN

END

So i need to run this procedure and have to save the lastLSN value to a variable,this procedure returns a binary object..please explain in brief