Thanks, I will try this. it really help me.

one more thing.. can i add indexes on replicated tables.. without running snapshot agent. will indexes take effects on replication. ??

Thanks again

oh yes, unfortunatly im using merge replication... but is it complicate or immpossible??

give me related articles if you have, and you can.

Thanks

hi, this is the good question, actually im also want this solution.. according my understanding ... you means i can change the length of a column of that table whcih...

Okay!!

You mean if i create an index on Server1 it will not take any effect on the replication.??

Thanks alot.

Noman 

you wrote that i should be aware that these indexses should not the part of replication. this is my questions how can i do this, bcz my table is in...

Yes that is I want.. but can u guide me again ..

how should i can not get indexes in the replication.

Thanx alot.

Noman

Thanx,

its restored.. by using the Script not through the wizerds. thanx any ways.

Thanx !!

I have solved my problem. thanks buddy. it was the same problem that you have mentioned.

Regards,

Noman

YES, i guess this is the real problem, my server is running on System Account.

but what if when i dont want to change it from system account to another account.?? bcz...

Yes if this error in popup window, then click ok or continue. it is for telling u that there is no ldf file.

please try this ..

yes !! for taking transaction log backup, your database recovery mode should be Full.

Noman

Thanx to u all,

Actually i have found the solution... that is:

-----------------

update sysobjects

set replinfo = 0

where replinfo = 128

and xtype = 'U'

------------------

Thanx to u all, i have solved my problem

Noman

how can i get this proc

smtpsendmail ?? if u have the script ..plz paste it.

Thanx

Thanx buddy, Its working..

I really love this ..

Thanx for prompt response..

Noman