.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 Article

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

I have SQL 2005 with Transactional Replication of a 20GB Database.

What is the correct process for adding a new table to an existing Publication?

The reason I ask is that I have used sp_addarticle to add the new table to the existing Publication but it hasn't replicated to the subscriber.

How do I get it to replicate to the subscriber? Surely I don't have to perform another snapshot of the entire database again do I? We don't have time to replicate 20GB just for 1 new table!

View Complete Post

More Related Resource Links

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.


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?



Initialize snapshot fro alternate location - multiple .bcp files for an article

I have to replicate over 50GB of data over a slow network.  I did not use the option to initialize snapshot from database backup because the replication articles contain row filters.  If I do that, I'll have to run a lot of scripts to remove the data and other unnecessary database objects on the subscriber. Instead, I created a workaround.  On the publisher, I first create the actual push subscription to the target subscriber on the publication.  This subscription is set not to initialize from snapshot.  I then created a second push subscription on the same publication, but the subscriber is a random database on the publisher server.  This second subscription is a dummy subscription set to initialize from snapshot - the purpose is to generate the necessary snapshot files.  I then reinitialized all subscriptions and generate the new snapshot files. On the subscriber, an empty database is created with the same tables as the publisher database.  I created an identical publication on this empty database, and a dummy push subscription on the target subscriber.  The subscription is reinitialized, and the snapshot files on the empty database is created.  These dummy snapshot files are then overwritten with the actual snapshot files created on the publisher, and then I synchronize the the dummy subscriptions with the actual sn

peer to peer replication, drop and add article of same name

We have peer-to-peer replication set up on our system (2005 EE). I would like to change the metadata of one of the tables (many of the tables actually, but right now I'm just trying to test out the process with just one table). As this is a high-availability system, I would like to stop the replication, make the changes on one node, verify that the changes are working, make the same changes on the other node, then re-enable replication. The ddl changes to the table are extensive enough that I have to clear them before executing. So I will handle re-populating the tables in a later step. Right now I'm just testing the process of stopping, doing ddl, then restarting. I am trying to implement this using scripts so as to minimize my clicking (and thus potential for mistakes) when doing it for real. I find that if I do the following process using the SSMS interface it goes smoothly with no errors (note that each step is conducted on both nodes unless specified): stop sync agents manually remove article: tblName1 with 'publications properties window' close 'publications properties window' make ddl changes to tblName1 (change column names, add columns etc. to a particular table) manually add article: tblName1 with 'publications properties window' re-enable agents But if I try the following, I get 'Peer-To-Peer topologies require identical articles in publications at all n

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

add new article to existing publication

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.

Making my own CMS - What if an article is more than NVARCHAR(MAX)

Hi,I'm looking to create my own cms and just thought of something that could be a problem.What if I write an article that is in excess of what NVARCHAR(Max) can store?What would you do?Run a quick bit of code to separate the article into smaller chunks?Or is there a better way?I know I could create some sort of key system where there is an "article" primary key and in the same table, there would be an "article part" integer, then run a query when I want to display the article to stick it back together, but is it a good idea or am I over complicating it?Thanks

Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?

I have already set up a Windows Server 2008 R2 Enterprise x64 with Hyper-V installed for trying out different features in SQL Server.  I'm interesting in trying out SQL Server Clustering.  I have only set up Windows 7 Enterprise x64, Windows 7 Pro x64,  and Windows XP PRO SP2 x86 VMs.  Can I use this VMs for SQL Server 2005 or 2008 Clustering?  Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?

place the news article

I have a news page... I am using ExecuteReader to read the data... then I am placing the news_title into an asp:Label... I want to know how can I place the news_text which is a ntext sql server field type? 

Problem with editing already published article

Hi We are using SharePoint 2007 standard edition in configuration of 2 x WFE + 1 x SQL backend (cluster). Only one WFE is exposed for the users and the secound one is just use for "central admin" and search crawling. Lately we found (and I'm not sure if this issue exist before) that in case of already published articles/news on SharePoint users who are the authors of them are finding issues when they are trying to edit and publish them again. Few information about our news/article solution: Solution used by our users was built based on "publishing infrustructure delivered out of the box from SharePoint" and the only customization we did, was writing special web part, which is presenting list of news/articles and letting user to create new news/article and during that creation process system is assigning special permission to created document = author is the only one who has option to edit this document (+contribute, +approve). and the problem: User is going to the main page and using our web part he is creating new article (as mentioned before during this process new document is created with use of sharepoint account (evaluated privilages), we braking permission inheritance chain, we adding +contribute, +approve rights for the user who initiated creation process and on the end we are doing check-in and check-out of the document). Now

Article properties


Please explain the following article property with respect to STD. Transactional Replication

Action if name is in use? What operations do the different options perform? How does replication sync in these cases? 

1.keep existing object unchanged

2.drop existing object and create a new one

3.delete data. if article has a row filter, delete only data that matches the filter

4.truncate all data in the existing object 

TX replication Article Properties


Please provide details/functionality on the following article properties--------

1.copy default value specifications

2.copy extended properties

3.copy file group associations

4.copy table partitioning shcemes

5.copy index partitioning schemes

6.copy user-defined statistcis

7.copy default bindings

8.copy rule bindings

9.copy spatial indexes

10.copy filtered indexes

11.copy data compression attribute

12.copy sparse column attribute

Adding triggers to a Merge Replicated published article in SQL Server 2008


Currently running merge replication on SQL Server 2008 10.0.1600 and I have a few questions around the correct procedures for adding and modifying triggers on published articles.  I've searched through the MSDN site and googled this but have not found any definitive information on correct procecdures.

1) When a new trigger is added to a published table do we just have to rerun the snapshot and then re-syncy the subscribers?  Just adding them does not seem to replicate them to subscribers.

2) When an existing trigger is modified should ALTER TRIGGER be used or should the trigger be dropped and then re-added?


SQL Server 2008 Merge Replication article triggers not replicating


Currently running merge replication on SQL Server 2008 10.0.1600 and having issues with adding and modifying triggers on published articles.  I've searched through the MSDN site and googled it but have not found any definitive information on correct procecdures.

We have a replicated table that had 1 trigger on it when it was added to the publication.  That trigger was replicated.  We have since added a 2nd trigger to the table and it is not being replicated to our other server.  I've checked the Article Properties and Copy User Triggers is set to TRUE.  The only difference is the new trigger has NOT FOR REPLICATION in it, but I thought that would only keep it from being executed if a row is effected by the MERGE process.

We have rerun the snapshot and are syncing continuosly and the trigger does not replicate.  Do I have to drop the tablefrom the publication and then re-add it?  Am I missing something? 


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?

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