.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

Publication without specifying every article

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server

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?

View Complete Post

More Related Resource Links

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.

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',

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 updatable subscriptions in SQL Server 2005, SvPk 2

Subscription to "Transactional Publication with Updateable Subscriptions" works only one way.  Changes take effect on subscriber, but the subcriber is unable to update data on publisher.   I have Sanpshot Agent process running under SQL Server Agent service account with login 'sa.'  All agents are running at the Distributor (Publishing Server.)   The subscriber is unable to connect to the Distributor using the SQL Server login.    Following is the error message I get:   Creating Subscription(s)... - Creating subscription for 'SQL3' (Warning) Messages Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------MSDTC on server 'SQL3' is unavailable.Changed database context to 'DB_SQL1_to_SQL3_on_3'. (Microsoft SQL Server, Error: 8501)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=8501&LinkId=20476   Please suggest procedure to end this dilemma.  The link has no info available.

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? 

SQL Server 2005 Merge Publication Filters

Is it possible to have Merge Subscriptions of a Publication (or publications) storing a different range of data.E.g. Sub1 contains the clients of one Sales Person only.Sub2 sontains the Clients of Many Sales Persons in one Division.Can you do this with one Publication?  How would you setup the filters for this then?Or do you have to have two separate publications of the same database.Pub1 filtering based on the SalesStaff ID = SUSER_NAME()Pub2 filtering based on the DivisionID=SUSER_NAME()Can someone describe how best to setup this scenario?

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

Can Not delete a publication in SQL 2005

Hi, everyone, I am new in SQL server 2005. I had setup SQL server 2005 P2P and Transactional replication. Somehow it did not work correctly. I tried to delete the publication. However I could not do it. have the same problem. When I tried to delete the publication, I got the publication " " does not exist.[SQL server error: 20026]. I tried to use sp_droppublication, it gave me error "the database is not enabled for publication". Nevertheless, I can see the publication in MS SQL Management Studio and Publication monitor with OK status. I could not find the distribution database either. Also, If I try sp_dboption[Database Name]. I get these rows returned. published auto create statistics auto update statistics  I tried to use sp_droppublication   @publication='publicationname', @ignore_distributor = 1.  It says "database is not enable for publication" I tried to enable publication (sp_dboption [database],'publication',true) It says "database option publication does not exist" Could you anyone has ideas to delete this publication? I am sorry I am not a programmer. Please give me more detail explanation if you can. Thanks.
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