Re-publishing and metadata deletion

I need to drop a few publications because they are located on the wrong hard
drive on the server. Before I republish these databases can I delete the
metadata tables? I would assume that if the publication is dropped then the
metadata tables become meaningless, is this correct? Which tables exactly can
I delete? I believe msmerge_contents and tombstone can be deleted, any others?
Thanks,
Pete
Can anyone help me?
Another problem, I am trying to delete a few subscriptions from a server so
that I can resubscribe the databases to the new publications but I keep
getting the error below. I have already dropped the publications and
recreated them in the new location, and the new subscriptions will not
synchronize, the error is "The process could not drop one or more tables
because the tables are being used".
The error I get when trying to delete the old subscriptions is:
"Error 14274: Cannot add, update, or delete a job (or its steps or
schedules) that originated from a MSX server. The subscription could not be
dropped at this time."
I have no idea what a MSX server is.
Please help,
Pete
"Pete" wrote:

> I need to drop a few publications because they are located on the wrong hard
> drive on the server. Before I republish these databases can I delete the
> metadata tables? I would assume that if the publication is dropped then the
> metadata tables become meaningless, is this correct? Which tables exactly can
> I delete? I believe msmerge_contents and tombstone can be deleted, any others?
> Thanks,
> Pete

Republishing

Hi
I want to republish data in sql server. Scenario is like
this.
SERVER A SERVER B SERVER C
Publisher --> Subscriber/Publisher --> Subscriber
Server A publish data (Merge/push to SERVER B)
Server B publish data (Merge/push to SERVER C)
Can be done this type of publishing.?
Is there any way to doing this type of publishing.
Thanks
Dishan
Yes this can be done.
Books On Line should have more information on it.
If you have trouble setting up, please respond to this thread with the
problems.
I will try to help.
Hope that helps
--Mahesh
[ This posting is provided "as is" with no warranties and confers no
rights. ]
"DishanF" <d700693@.hotmail.com> wrote in message
news:550901c480e9$7fac2560$a501280a@.phx.gbl...
> Hi
> I want to republish data in sql server. Scenario is like
> this.
> SERVER A SERVER B SERVER C
> Publisher --> Subscriber/Publisher --> Subscriber
> Server A publish data (Merge/push to SERVER B)
> Server B publish data (Merge/push to SERVER C)
> Can be done this type of publishing.?
> Is there any way to doing this type of publishing.
> Thanks
> Dishan
|||Can you send me any web urls ?

Reprot description not getting updated.

I publish an RDL to report server using web service, then later i have a
modified RDL which has the the report description changed. I republish with
"Overwrite" on my existing reprot using webservice. The description is not
getting updated in report manager.
If i edit the new report form report manager and look at the rdl it show the
new description but it will always dispalys the old description in the
description textbox.
Any idea how i could force it to update?Try manually deleting the description via the report manager interface and
then re-deploy.
Colin
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>I publish an RDL to report server using web service, then later i have a
> modified RDL which has the the report description changed. I republish
> with
> "Overwrite" on my existing reprot using webservice. The description is not
> getting updated in report manager.
> If i edit the new report form report manager and look at the rdl it show
> the
> new description but it will always dispalys the old description in the
> description textbox.
> Any idea how i could force it to update?|||Users cannot access report manager. They have to do this through our custom
interface that uses webservice to update reports.
"Microsoft" wrote:
> Try manually deleting the description via the report manager interface and
> then re-deploy.
> Colin
>
> "vRam" <vRam@.discussions.microsoft.com> wrote in message
> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
> >I publish an RDL to report server using web service, then later i have a
> > modified RDL which has the the report description changed. I republish
> > with
> > "Overwrite" on my existing reprot using webservice. The description is not
> > getting updated in report manager.
> >
> > If i edit the new report form report manager and look at the rdl it show
> > the
> > new description but it will always dispalys the old description in the
> > description textbox.
> >
> > Any idea how i could force it to update?
>
>|||Delete and redeploy is the only way. I assume through the web service you
can delete it as part of the deploy process.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:9E62EE10-0652-4E70-BFD5-54FB410AAE70@.microsoft.com...
> Users cannot access report manager. They have to do this through our
> custom
> interface that uses webservice to update reports.
>
> "Microsoft" wrote:
>> Try manually deleting the description via the report manager interface
>> and
>> then re-deploy.
>> Colin
>>
>> "vRam" <vRam@.discussions.microsoft.com> wrote in message
>> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>> >I publish an RDL to report server using web service, then later i have a
>> > modified RDL which has the the report description changed. I republish
>> > with
>> > "Overwrite" on my existing reprot using webservice. The description is
>> > not
>> > getting updated in report manager.
>> >
>> > If i edit the new report form report manager and look at the rdl it
>> > show
>> > the
>> > new description but it will always dispalys the old description in the
>> > description textbox.
>> >
>> > Any idea how i could force it to update?
>>