Yes .

I really need to shrink the log file, it is fast becoming a performance issue.

how will log shipping help me to achieve this?

Most important step I missed

First step is

USE MSDB

🙂

If you know the name of the job thats doing the backup operation then you can use the following

select command from sysjobsteps where job_id

=(select job_id from sysjobs where name='<name of...

Check for the properties of the table if foreign key has been added to MYTABLE..

If yes, Go to tools -> options -> Designer - > table and database designers and...

This issue is resoleved ..Thanks for nothing

I had been unable to accomplish this, but as a work around I created the replication environment in my local on restored production DB backup. As here too i was...

sp_browsereplcmds is not a recognised command in SQL server 2000. It works on 2005.

Please make sure that you have installed Service pack 4. I recently configured my server for remote access using 2000 +SP4.

hope it helps.

I will also vote for replication only, but of the two tools, redgate is better and hasslefree.

After much struggle, I have found out the only thing missing, to configure the client server setup on my local, was SP4.

I installed and the log now shows

"2010-04-13 13:49:58.09...

Thanks for immediate response.

I am now able to fix the issue. The issue was certainly due to the version and my utter lack of foresightin not installing the 2005 version...