You can copy the sql script of step job that you want to merge with first job. And then create step 2 inside the first job. Save this job as...

Can you also let me know How I can update stastics

UPDATE STATISTICS TableName

Will it enhance the execution of queries.

Thanks

Jaswinder

Do I have to stop the replication agent for that subscription only where I have to backup and restore the Database.

Or should I have to stop the whole replication?

Thanks for advise.

How to apply sql profiler on table and what contents to select.

Pl advise

On secure side,I did take backup of DB and restore on another server and found DB shrink to approximately 50%.

As on actual server where DB resides, Many users are getting...

On secure side,I did take backup of DB and restore on another server and found DB shrink to approximately 50%.

As on actual server where DB resides, Many users are getting...