General information
Forum:
Microsoft SQL Server
Title:
Record count of each table
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only