.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

add new article to existing publication

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
I have an existing publication with 10 articles configured for Transactional replication. The replication is running fine. Now I wish to add another table (article) to this publication. My requirement is to ensure that I don’t need to generate a snapshot of all the articles being published, if I add a single article only that particular article should be published.

View Complete Post

More Related Resource Links

automatic adding new article to existing publication



I have two servers with SQL Server 2005 Enterprise Edition. There are several databases on it. I implement snapshot replication (every hour) and everything works fine. But developers are creating new tables, views and etc every day. How i can automaticaly add it (tables, colums, views etc) in existing publication (i need to replicate all data in database). Or i need to use another solution like database mirroring?

Best regards

Issue while Adding article in existing publication Transactional Replication.


We are facing difficulties adding article to an existing publication.The replication was setup by restoring the backup on subscriber  from publisher and changed the setting Intilialize from Backup =True

Used the following steps but it almost bought down the system.




@publication = N'marcus8rpl',

Transactional Publication With Article Using DATE Datatype Causes Snapshot Agent to Fail with Error

So I am using SQL Server 2008 Enterprise Edition (64Bit) and have run into a strange problem that is baffling me. I have two tables that I need to replicate.  They are identical in specification except the name (one is for monthly stats and one daily stats) CREATE TABLE [dbo].[statsDailyLite]( [EntryDate] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsDailyLite] PRIMARY KEY CLUSTERED ( [EntryDate] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO CREATE TABLE [dbo].[statsMonthlyLite]( [EntryMonth] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsMonthlyLite] PRIMARY KEY CLUSTERED ( [EntryMonth] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO They both conatin a thousand or so test rows of data, and they are both in a transactional publication going to another SQL 2008 box. Now when the tables are empty

Publication without specifying every article


I'm trying to create replication on an Great Plains Dynamics database. It's about 100 GB, however, there are thousands of Stored Procedures, hundreds of tables, views and UDFs. Using the New Publication Wizard, it locks up for about 15 minutes on the "Articles" page and when it does resume, takes a couple hours to create the publication. If I have it generate a script to create the publication, the script files is 27 megabytes large and has 230,000 lines, mostly just sp_addarticle statements.

Trying to create the subscription on a second server runs for about 10 hours and still never finishes. By that time, my nightly window has closed, so I have to stop it. And it hasn't even started inserting the BCP files. The MDF files are the same size as when they're first created.

I think restoring from a BAK file on the subscriber (rather than a snapshot) is the way to go. However, my question is, is it possible to create the initial publication without specifying each individual article it has to add.

The subscribing server will serve as both a disaster recovery and a SSRS database, to get the report queries off our production server. Because of the disaster recovery need, I must attach all tables, all prcos, all views, etc.

Can't I just say something like ADD ALL ARTICLES?

Issue while adding article to existing subscription(Transactional Replication)


We are haing issues while adding article on existing subscription.

The replication is setup with Initialize from backup=true.

Below is the command I tired to use aftet transfering the rows thru export import wizard but the table on the subscriber isnt refreshing.

exec sp_addarticle @publication = N'marcus8rpl' , @article = N'appnames' , @source_owner = N'dbo' , @source_object = N'appnames' , @type = N'logbased' , @description = null , @creation_script = null , @pre_creation_cmd = N'NONE' , @identityrangemanagementoption = N'manual' , @destination_table = N'appnames' , @destination_owner = N'dbo' , @vertical_partition = N'false' , @ins_cmd = N'CALL sp_MSins_dboappnames' , @del_cmd = N'CALL sp_MSdel_dboappnames' , @upd_cmd = N'CALL sp_MSupd_dboappnames'

Merge Replication - Add table to existing publication


I added a table to an existing publication and then generated a new shapshot.  The merge agents then sent the new table and data down to the sunscribers as planned.  The issue is that at the next cycle the merge agent re-initilizes the table again.  This happens over and over again.  If I stop and restart the agent I can watch it send the schema back down to the subscriber.  Any thoughts are appreciated.



Feature available to Silverlight 4 with VS 2010.

In Part I of this article series we have seen some features available to Silverlight 4 with VS 2010. We will continue to explore more in this article.

Article commenting by line number


I'm wondering what's the best way to approach an online article system that allows users to comment by clicking on the line they are commenting about? Essentially the same way Adobe Acrobat works with comments where you can click anywhere and the text is saved for that location.

I'm assuming a mix of jQuery would be the crux of the interface. The system would need to save comments so that when another user logs in, they will also see the other comments but they can´t edit them - only add their own.

Any suggestions would be great.

reference from menubuttons to text parts in article on the same page


Hi, I'm searching now for hours but couldn't find it.Cry

In my menu i have several buttons which (by a <a href..) should go the a part of an article that is in the same form.

Menu button : What is a database should go to the page default.aspx and in there is an article published.
A part of this article is having a piece of text about "what is a database"

Menu button: how to make a query should go to this same article in the same page but then to the part that is have the piece about the query. The next could be an example of what i'm doing:

    <li><a href="default.aspx ?????>what is a database</a></li>
    <li><a href="default.aspx ?????>what is a query</a></li>

Where my question marks are, there should be a connection to that particular piece of text.
In each article part there is an ID="text1" and the second part id="text2"

How shoudl i do that, Should i use a question mark.
Please give me some guidance how to structure the <li> statement or a pointer where I can read about it.


URL Routing and Existing HttpHandler problems


Hello everyone,

I have a problem:

I am currently using 2 features: 

1. HttpHandler

Registering the path="res.aspx" verb="*"

2. URL Routing:

Registering with this pattern: "Company/Edit/{*companyId}","~/CompanyEdit.aspx"

In my CompanyEdit.aspx page, I used httphandler res.aspx to generate some images at client.

  • res.aspx?img=1
  • res.aspx?img=3

Now the problem is here, the page is load success with companyId = "12345", but when the images was loaded at client, it loaded the CompanyEdit.aspx again and show error with wrong id.  

I have debug and find the problem that because when image's urls were generated to client with url=res.aspx?img=1, url=res.aspx?img=3, the asp.net will understand that they are Company/Edit/res.aspx?img=1, Company/Edit/res.aspx?img=3 when it maps with URL Routing pattern.

=> So the CompanyEdit.aspx was load again with wrong id (id now is "res.aspx"). 

So, do you have any ideas to solve this problem, or other design.

Thanks, and best regard

XML Schemas: Take Advantage of Existing External XML Schemas with a Custom Import Framework in ASP.N


Over the years, many industry-standard XML schemas and dialects have been developed. These industry-specific schemas embrace the original purpose of XML and are extremely valuable in promoting and supporting B2B interaction. Unfortunately, the ASP.NET Web Services runtime does not allow developers to directly reference external schemas from within their XML Web Services interface (the WSDL file). This article builds an external schema framework as an extension to the ASP.NET Web Services runtime to enable you to reference external schemas within your XML Web Service interface.

Scott Short

MSDN Magazine December 2002

Connect to existing sql 2005 database


Hello There,

I had successfully restored sql 2000 database to sql 2005. It works like charm

Now i am creating a database model in MVC

I follow these steps

Right click on model > ADO.NET entity data model > Generate from database > New connection (Microsoft sql server) > server name > select or enter database name

But no server name AND database name show in both drop down lists. When i mannually enter database name (which exists in sql 2005) then click on TEST CONNECTION. It gives follwoing error

"A network-related or instance-specific error while establishing a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections.

Kindly help me with this


Cannot add an article to the specified folder



I've set up a sharepoint knowledgebase on my intranet site and all seemed fine.

The problem I have is that if I create a subfolder, I cannot create articles in that subfolder, as they appear in the root.


Steps taken:

  1. New|Folder - create a new folder in the knowledge base root
  2. Enter the folder
  3. New|Knowledge Base Article
  4. Verify that the path on the top of the new article edit page is "...Knowledge Base > New Folder"
  5. Save article
  6. Verify New Folder is empty and article can be found in the root of the knowledge base  

Uploading an article to the new folder is fine, as is editing/deleting the new folder itself.

Any ideas?



Question on using variations on an existing site


I've been using MOSS 2007 for my company's CMS system for the last 2 years or so. Recently, the marketing department has asked us to include the option for multilingual support so naturally, I looked to using variations to accomplish this, however, the site was setup without variations since this was "definitely" not a requirement back when we setup the site.

My problem is when I enable variations, it seems to create new sites off of the root (e.g. English, Spanish, French), however,  it isn't copying anything from the Root site that already exists or any of it's subsites or pages. Is there any to keep my existing site content intact and still use variations, including all of the update features?

Thanks in advance

Is it. Is it really?

Overwriting Existing InfoPath 2003 Forms



I'm having a big problem in my Sharepoint Environment.

So far I've created a form in InfoPath 2003 and successfully published it to a Form Library. It's also submitting correctly (at least at first).

Now after I added a couple forms, let's say three forms with unique file names, and then I open the second one, make a change and submit it again, it disappears from the "All Items" list. I can still see it sitting in the "Explorer View", but it's missing in the other. Now when I try to "Fill out a new Form", it either won't show up in the list or it will show up but with the column fields that have been populated previously.

We're using WSS 2.0 and InfoPath 2003.

I used this guide to create the unique filenames: http://www.codeproject.com/KB/sharepoint/SharePointSubmitInfoPath.aspx

In my view, the issue lies in trying to overwrite existing files and not appearing in the list.

Any help is much appreciated !!!


Thanks in advance.

Marvin Sugirin

Info Path form when modified by using UTF-8 encoding having issues with existing 'iso-8859-1' char



I am modifying the infio path form 2007 from my state machine workflow to constantly update the status fields in the request form.

below is the method i created for the same..

private void updateInfoPathRequestForm(string xpathNode, string nodeValue)
            SPUserToken token = workflowProperties.Web.CurrentUser.UserToken;
            using (SPSite _site = new SPSite(workflowProperties.Site.ID, token))
                _site.AllowUnsafeUpdates = true;
                using (SPWeb _web = _site.OpenWeb(workflowProperties.Web.ID))
                    SPListItem item = _web.Lists[workflowProperties.List.ID].Items[workflowProperties.Item.UniqueId];

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend