Dinakar is right.. you should drop all FKs on Subscriber database.

Bhushan

The first one gives better performance because the inner joins are much better than inner queries. The reason was the inner joins use less number database reads, less CPU utilization and total server...

Run SP_SCRIPTPUBLICATIONCUSTOMPROCS '[PUBLICATION NAME]' on source database and that will generate a script. Copy the script and execute the script on Destination database. If you have any questions ......

Run SP_SCRIPTPUBLICATIONCUSTOMPROCS '[PUBLICATION NAME]' on source database and that will generate a script. Copy the script and execute the script on Destination database. If you have any questions ... let...

If it's just a log table then why can't you use "Truncate Table" script at off-peak time. If its hard you to access the system on off peak hours then create...

Thank you very much John and Gary....It worked and saved my time.

Bhushan

I am talking about Tempdb database log file not the main database log file. I tried to change the location of the tempdb log file but it is thrown an...

Hi

I am not sure about the correct answer but one of the potential reason for database in a suspect is torn pages. If there is power failure, any data...

Thank you Chris

Bhushan

Wonderful.

Its great and working fine. Thank you so much !!! Do you have any idea where to look the subscriptions after creating push subscriptions. Push subscriptions are created in my...

Hi chris,

It worked and thanks alot

Bhushan Kalla

Thank you Chris

I will try this and let you know the results.

Bhushan

Thank you Chris

I will try this and let you know the results.

Bhushan

Thank you Chris

I will try this and let you know the results.

Bhushan

Thank you very much Ray... Your example is very nice and easy to understand. It was really useful to me.

Once again thanks for your time and help.

Bhushan Kalla