You can't directly parameterize the table name in a query. Try using Dynamic SQL.
EXECUTE ('select count(*) from ' + @dest_tabname)
-Mike
>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