thanks Markus

thanks Chris , do i need to reboot the box after running

sp_configure for AWE?

further to my question if i simply replace(overwrite) all system and user defined DB's will it work?

do you mean ,your replication failed and you need to see how many records are pending to be replicated to subscriber end ?

sorry friends i could not reply to the thread as i was out for quite some time,but yes the question was same when i create the table columns get created...

Great Frank ,Frank one more question for you , through query analyzer i can specify the filegroup while creating new table .

is there any way in enterprise manager also where...

hmm ,thanks it means without a kind of interm/temp table i cannot simply move my table to different filegroup.

am i correct

thanks Frank ,but there is any way to move my existing table to other file group?

thank you very much

thanks,so if i update the column in sysarticle directly from 31 to F3 option ,and give the snapshot again so will it work?

thanks chris for your suggestion ,yes you are correct,but the issue is i cant modify the existing code.

but very thankful to you all

this is the view 'Interface'

select top 100 percent log.InterfaceID

 , log.Component

 , log.XmlMessage

 , log.ErrorCode

from interface log (nolock)

Left Outer Join ErrorMessage err (nolock)

on  log.errorCode = err.AppErrorCode

order by log.lastmodifieddate desc

and i am using

select  top 100 * from interface order...

Basically it is fetching through view and yes order by column is with clustered index(primary key)

that's true i am getting column at subscription also but i am not getting new data for that column in subscription ,which i am getting only after running snapshot again.

any...

Can you please guide me how to stop replication for some time,i dont want to disable the replication.

and can i avoid full snapshot after adding/Changing the column?

or if i cant...