Thanks very much again! Yet again this forum has been very useful.

Regards,

Vivek

Hi Sujith

Please use followoing stored procedure.

sp_mergemetadataretentioncleanup

Regards,

Vivek

Hi Brian

I am having the same problem and i am using...

Has anyone come across anything like this?

Any help will be much appreciated guys!!

Certainly.

Thanks SQL DBA 808.

Thanks a lot again roy.

I have used replication scripts so many times before and they seem to be functioning fine as far as all the required bits are changed to...

Hi Roy

Thanks for your reply but the error was occuring because there was some metadata left behind when i deleted old subscriptions and publications.

Thanks for getting back to me though.

Vivek

Hi Abhay

Thanks a lot for your reply but i have managed to resolve this issue.

It was a problem with table name and stored procedure wasn't taking care of it.

Thanks again.

Vivek

Yes, It does.

When you run the job set does the database context change...

Thanks for your reply.

I have tried doing running following statement on production SQL Server but that doesn't resolve the issue.

RegSvr32 SQLTaskConnections.dll

Vivek

http://msdn.microsoft.com/en-us/library/ms175008.aspx

I have used script listed on this page but i have modified it to...

Also, go through following. its quite helpful article.

http://technet.microsoft.com/en-us/library/cc966523.aspx

The only problem with that example is its using cursors and people dont really like them because of their resource hungry nature.

I'd say replace this cursor with better code to...

Also, you might want to perform a bit of clever index maintenace.

You might want to reorganise indexes with fragmentation below 30% and rebuild indexes with fragmentation above 30%.

Something like that....

If you are rebuilding index then you wont have to do update statistics manually in your maintenance plan.

Vivek