Prithvi - First you need to drop the existing subscription.

Then add the article

Then add the subscription.

This will work.

hi

try this out and run the result set as a script.

set nocount on

declare @tblname varchar(60)

declare indx cursor for

select table_name from information_schema.tables where table_type='base table'

open indx

fetch next from indx into...

select * from total_spending

where amount in (select top 6 amount from total_spending order by amount desc)

raghu

set the auto shrink option in the database

raghu