Addign Column to a replicated Table

Hello,
Is there a way to add a column to a replicated table
without deleting the subscription and recreating it?
Thanks,
niv
Niv,
have a look at sp_repladdcolumn in BOL.
HTH,
Paul Ibison
|||Paul,
Am I correct to assume that I will have to run this stored
procedure on both the publisher and the subscriber.
niv

>--Original Message--
>Niv,
>have a look at sp_repladdcolumn in BOL.
>HTH,
>Paul Ibison
>
>.
>
|||Niv,
just the publisher will do and synchronization will propagate it down to the
subscriber, and then update the relevant objects.
Regards,
Paul Ibison

Add new user with web service

Hi there,
Would like to manage users (adding, deleting) and give them browsing rights
to reports programmatically, using the web service. Can't find the method
allowing me to do it anywhere.
Am I missing something ?
Cheers
ggThere are several methods depending on what you want to accomplish. Given a
user you can give them system level privledges using SetSystemPolicies() or
privledges on individual items using SetPolicies(). A policy is a mapping
of a user to a role. Roles are managed via
CreateRole()/SetRoleProperties/etc.. and define the specific privledges you
want to assign. For your purposes you might want to use the predefined
"Browser" role.
Jon Heide
SQL Server Reporting Services
----
Everything you need to know about SQL Server Reporting Services:
http://www.microsoft.com/sql/reporting/default.asp
----
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----