How can I make changes to my Publisher tables e.g change columns ,

I have a transactional replication with one publisher and one subscriber.
This is working fine. Now my developers need to make changes to the
production database. They would like to change columns, add new indexes, etc.
What is the bet way to do this without much down time?
George Gopie
freaking developers. You can use sp_repladdcolumn or sp_repldropcolumn for
changing columns. To add new indexes use sp_addscriptexec for subscriptions
deployed via unc's.
If your environment's schema is volatile (i.e. changing all the time) you
should look at log shipping or SQL Server 2005.
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
"georgeg" <ggg@.hotamil.com> wrote in message
news:B980F6D1-CF64-4A7D-B513-9715D427A898@.microsoft.com...
> I have a transactional replication with one publisher and one subscriber.
> This is working fine. Now my developers need to make changes to the
> production database. They would like to change columns, add new indexes,
etc.
> What is the bet way to do this without much down time?
> --
> George Gopie
>

How can I identify the Push Subscriptions as Subscribers Server using SQL-DMO?

Hi..
I made a Transactional Replication using Push Subscriptions..
I wonder how can I identify the Push Subscriptions as Subscribers Server
using SQL-DMO?
In the SQL-DMO tree(here's URL :
http://msdn.microsoft.com/library/de...con03_39yd.asp )
I cannot find PushSubscriptions Object in the tree.
Any clues will help..
TIA
jh.
I am confused by what you are a looking for.
If you are looking for all the subscriptions at a subscriber use the
Subscription class with the EnumAllSubscriptions method.
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
"joohyoung yoon" <adiuvame@.hotmail.com> wrote in message
news:ujsTg940FHA.700@.TK2MSFTNGP10.phx.gbl...
> Hi..
> I made a Transactional Replication using Push Subscriptions..
> I wonder how can I identify the Push Subscriptions as Subscribers Server
> using SQL-DMO?
> In the SQL-DMO tree(here's URL :
>
http://msdn.microsoft.com/library/de...con03_39yd.asp )
> I cannot find PushSubscriptions Object in the tree.
> Any clues will help..
> TIA
> jh.
>

How can I get a (count) of how many transactions the log reader is wating on?

I need to know if replication is running behind. I have already queried
with distribution db for this subscriber , but it's telling me there are
no transactions waiting.
the agent history on the log reader shows it moving across data to the
distributor normally, but when i try to shrink the translog its telling
me that it can't because there are transactions marked for rpelication
that have not been pushed over yet.
here's what I ran on the distrbutor to get the trasnactions waiting
Select * from dbo.MSpublisher_databases where publisher_db = 'cpk01'
(to get publisher id)
then
Select count(1) from dbo.MSrepl_transactions where
publisher_database_id = 13
(to get transaction count)
tia
-comb
Comb,
querying this view (distribution database) is what you need:
MSdistribution_status.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||In article <Ochx0lzBGHA.140@.TK2MSFTNGP12.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> Comb,
> querying this view (distribution database) is what you need:
> MSdistribution_status.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
Thanks Paul.
-comb