Adding new column in published table

hi,
I wish to add a new column in published table. i know using
sp_repladdcolumn we can add columns. but i wish to know using
sp_repladdcolumn is better or drop the replication then add the column and
recreate the replication is better.
Can anyone suggest the right way ?
Thanks in advance
Petchikumar.
"Petchikumar" schrieb:
> hi,
> I wish to add a new column in published table. i know using
> sp_repladdcolumn we can add columns. but i wish to know using
> sp_repladdcolumn is better or drop the replication then add the column and
> recreate the replication is better.
> Can anyone suggest the right way ?
> Thanks in advance
> Petchikumar.
Both ways are correct. sp_repladdcolumn (with reinitialization of the
subscribers) will be a little quicker as you save the time of dropping the
replication ...

Adding new column in published table

hi,
I wish to add a new column in published table. i know using
sp_repladdcolumn we can add columns. but i wish to know using
sp_repladdcolumn is better or drop the replication then add the column and
recreate the replication is better.
Can anyone suggest the right way ?
Thanks in advance
Petchikumar."Petchikumar" schrieb:
> hi,
> I wish to add a new column in published table. i know using
> sp_repladdcolumn we can add columns. but i wish to know using
> sp_repladdcolumn is better or drop the replication then add the column and
> recreate the replication is better.
> Can anyone suggest the right way ?
> Thanks in advance
> Petchikumar.
Both ways are correct. sp_repladdcolumn (with reinitialization of the
subscribers) will be a little quicker as you save the time of dropping the
replication ...

Adding new column in published table

hi,
I wish to add a new column in published table. i know using
sp_repladdcolumn we can add columns. but i wish to know using
sp_repladdcolumn is better or drop the replication then add the column and
recreate the replication is better.
Can anyone suggest the right way ?
Thanks in advance
Petchikumar."Petchikumar" schrieb:
> hi,
> I wish to add a new column in published table. i know using
> sp_repladdcolumn we can add columns. but i wish to know using
> sp_repladdcolumn is better or drop the replication then add the column and
> recreate the replication is better.
> Can anyone suggest the right way ?
> Thanks in advance
> Petchikumar.
Both ways are correct. sp_repladdcolumn (with reinitialization of the
subscribers) will be a little quicker as you save the time of dropping the
replication ...

Adding index to published table

Is this possible?
How would I do it?
Rob
Rob,
if it's just to exist on the publisher then you can just go ahead and add it
using EM or TSQL. This index won't be propagated to the subscriber, and even
in SQL 2005 with the option to replicate schema changes this is true. To be
sure to get the index to all subscribers, you can use sp_addscriptexec.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi,
So can I also manaully add /modify /drop the same indexes at the subscriber
using EM and T-SQL as well? Planning to do some major performance tuning in
my application soon.
TQ in advance.
"Paul Ibison" wrote:

> Rob,
> if it's just to exist on the publisher then you can just go ahead and add it
> using EM or TSQL. This index won't be propagated to the subscriber, and even
> in SQL 2005 with the option to replicate schema changes this is true. To be
> sure to get the index to all subscribers, you can use sp_addscriptexec.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Yes - index alterations are not seen as schema changes in that regard. The
same is true in SQL Server 2005 where there is the option of automatic
schema alterations being replicated - ie indexes aren't.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Adding DataSet as DataSource to Report Published on Report Server from ClientSide

Hi

I am Creating Click Once Windows Application with Reporting Services 2005.I have created Report and Published on Report Server.In my windows application I am successfully able to view my published report through report viewer control.

Now in my application I am getting a dataset from my custom webservice. I want this dataset data to be added to my report as datasource at runtime on Client Side ,as my report is on Report Server.

waiting for help!!

Thanks in Advance

Pankaj

The report server does not support passing in data sets for reports to run with. You could use the Viewer control in local mode and have the viewer show the report with that data set. Of course by doing this you would loose all of the server add ons (client print for the web control, subscriptions, security, etc).

-Daniel

|||

Hi

Thanks for suggession. But will you please tell me which functions/class I have to use to set my new dataset as datasource to my report at client side.as you have mentioned to use reportviewer as localmode.will you please clearly specify.

Thanks

Pankaj

|||

Hi Daniel

Or is it possible to get report from reportserver at client side and make it as local report and use it as local report and add datasources to it.?

-Pankaj

|||

You can dynamically set the data set using .LocalReport.DataSources.Add. If you look on http://www.gotreportviewer.com/ you will find examples to go by.

You may also want to look into writing a custom Data Processing Extension. By doing this, any report on the server could use your data extension to populate it's data. You can find more information here http://msdn2.microsoft.com/en-us/library/ms154655.aspx.

I'm not sure exactly what you are trying to accomplish so it's hard to say which is the best approach for your problem.

-Daniel

|||The following article may help you to find the most appropriate solution.

Adding column to table

Just wanted to check. Running merge replication on SQL 2000. If I add a
column to a table that is a published article, I assume I just run
sp_repladdcolumn is that correct and is that all I need to do in order for
the laptops to get the change with their next synch? Also, what do I set
the value for @.force_reinit_subscription to? Thanks.
David
Yes. However I believe you need to set @.force_reinit_subscription and
@.force_invalidate_snapshot to 1.
Basically these switches will stop your script from working if they are set
to their defaults of 0. If you set them to 1 your scripts will run but you
may have to reinitialize your subscriptions.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23IOG4PPOHHA.3872@.TK2MSFTNGP06.phx.gbl...
> Just wanted to check. Running merge replication on SQL 2000. If I add a
> column to a table that is a published article, I assume I just run
> sp_repladdcolumn is that correct and is that all I need to do in order for
> the laptops to get the change with their next synch? Also, what do I set
> the value for @.force_reinit_subscription to? Thanks.
> David
>