How to add tabls to published article without recreating snapshot?

Hi experts:

We have 4 SQL SERVER 2000 servers linked via replication, and due to business changes we have to add one table to the published databases. And the existed database has more than 20g, recreating the snapshot and re-init replication is not allowed as the business cannot be stopped more than 1 hour. So my question is how to add tables to the published article without recreating the snapshot?

By that is not possilbe, can we publish one new article on the same database?

Thanks in advance!

Ron

Hi Ron,

If you are using merge replication, you have to regenerate the snapshot for the entire publication after you added the new article. For snapshot\transactional replication, the snapshot agent will only generate the snapshot for the new article if the immediate_sync property of your publication is set to 0. In any case, you can always put the new article in a separate publication instead.

Hope that helps,

-Raymond

how to access web.config

I am using vs2005 and have a solution file with 4 projects, 2 of which are presentation layers (admin sections), 1 is a business logic layer, the other a data access layer.

The data access layer project is simply a class library that will provide data access functionality. Im using a dataset (xsd) to create my data access objects. My question is how do I select a connection string from the web config file (which is in each of the presentation layer projects) as the data access layer is a class library there is no web.config. Using the connection string selector in the dataset wizard doesnt show any available connection strings.

Reference the System.Confiuration dll and you can use the System.Configuration classes to obtain this data.
In 1.1 you use the ConfigurationSettings class
in 2.0 you utilise the System.ConfigurationManager and this supports the System.ConfigurationManager.ConnectionStrings for <ConnectionStrings> entries.

how to access sql server on windows small businness server 2003

Hello,

I have windows small business server 2003 premium installed, I can see the server service manager but can not start any service(nothing is listed).
How do I set it up?

I can not find the enterprise manager to create a database.

Thanks for your help

The Small Business Server 2003 comes with SQL Server 2000 for 75 users, ISA(internet security server) and Exchange 2003 also for 75 users, how to install the first two is covered below by Microsoft. Hope this helps.

http://download.microsoft.com/download/8/2/4/824e18ac-8503-4277-aeb6-b3f24c316f6c/PremiumInstallSteps.htm