Hi all,

I need a procedure from which i will get all the record count of each table which is replicated.
i made following procedure

Create procedure udsp_count_records
AS
declare @dest_tabname sysname
Declare record_count cursor
For

Select a.name
From ors..sysobjects a
Where a.xtype = "U" and
a.replinfo = 32

Open record_count
Fetch Next From record_count into
@dest_tabname

While @@fetch_status = 0
Begin
set nocount on
select @dest_tabname

select count(*) from @dest_tabname

Fetch Next From record_count
Into @dest_tabname
end
close record_count
deallocate record_count


but i got an syntex error near @dest_tabname in the line
select count(*) from @dest_tabname

any body have any clue. or any other idea.

Thanks,
....ashish