Add table to replicated database

How do I add a table to a replicated database using the Enterprise
Manager? I know to use the Publications properties to add a column,
but want to be sure to add a table correctly.
It's the same dialog box. Click the checkbox to show unpublished articles
and then select the table. In this sense it is different to adding a column,
as the table must already exist. After that, run the snapshot agent to
create the bcp files for the table. If the publication is a merge one, a
complete snapshot is created although only the new table will be used. On
synchronization, just the new article will be sent to the subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Add MS SQL 7.0 server in MS SQL 2000 SEM

Hi.
Rookie question.
Is it possible to add a MS SQL 7.0 server in a MS SQL 2000 Server Enterprise
Manager consol? I've added a login on the MS SQL 7.0 server, dedictaed to
the MS SQL 2000 login, but the 7.0 server appear to be "not associated with
a trusted SQL Server connection" when I try to register the 7.0 server in
the 2000 consol.
Please guide me on this one if you can.
Regards
Mr. Smith
Hi
SQL Server 2000 EM can manage SQL Server 7.0 installations.
Your problem is security. Are you logged on using an account that has
permissions on the SQL Server 7.0 server and domain? If not, you need to be
given the rights. Else, connect using SQL Server security by passing in a
Username and Password.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:e08lOn32EHA.924@.TK2MSFTNGP14.phx.gbl...
> Hi.
> Rookie question.
> Is it possible to add a MS SQL 7.0 server in a MS SQL 2000 Server
Enterprise
> Manager consol? I've added a login on the MS SQL 7.0 server, dedictaed to
> the MS SQL 2000 login, but the 7.0 server appear to be "not associated
with
> a trusted SQL Server connection" when I try to register the 7.0 server in
> the 2000 consol.
> Please guide me on this one if you can.
> Regards
> Mr. Smith
>