.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

Preventing schema changes from replicating

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

SQL 2008 R2

Is there any way of preventing a table schema change (column addition) from replicating to its subscribers without stopping replication of the table??




View Complete Post

More Related Resource Links

How to extract a schema from a sql server database



  I need to extract or get the schema from tables in my databse and what is the best way to do it. Is there any third party tool to do it??


Any idea will be appreciated..



Contract-First Web Services: Schema-based Development with Windows Communication Foundation


Schema- first contract-first modeling of Web Services gives you the ability to model your contracts with an XML-centric mindset. This process keeps you focused on universally acceptable types and the hierarchical data structures that can be represented in XML.

Christian Weyer, Buddhike de Silva

MSDN Magazine October 2009

Class To Contract: Enrich Your XML Serialization With Schema Providers In The .NET Framework


The Microsoft .NET Framework 1.x provided minimal options for mapping classes to schemas and serializing objects to XML documents, making this sort of mapping quite a challenge. The .NET Framework 2.0 changes all this with Schema providers and the IXmlSerializable interface.

Keith Pijanowski

MSDN Magazine June 2006

Data Points: Updating Data in Linked Servers, Information Schema Views, and More


Every day a developer somewhere needs to write code to iterate through SQL ServerT system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.

John Papa

MSDN Magazine November 2004

Web Services: Extend the ASP.NET WebMethod Framework by Adding XML Schema Validation


WebMethods make the development of XML Web Services easier by encapsulating a good deal of functionality, but there is still a lot of underlying XML processing that you have to be responsible for. For example, WebMethods do not validate messages against the implied schema. Because they are not validated, the response that's returned can result in unintended consequences. To address this, the authors extend the WebMethod framework by adding XML Schema validation through a custom SoapExtension class.

Aaron Skonnard and Dan Sullivan

MSDN Magazine July 2003

Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000


SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003

Design: Place XML Message Design Ahead of Schema Planning to Improve Web Service Interoperability


Web Services are all about exchanging data in the form of XML messages. If you were about to design a database schema, you probably wouldn't let your tool do it for you. You'd hand-tool it yourself to ensure maximum efficiency. In this article, the author maintains that designing a Web Service should be no different. You should know what kind of data will be returned by Web Service requests and use the structure of that data to design the most efficient message format. Here you'll learn how to make that determination and how to build your Web Service around the message structure.

Yasser Shohoud

MSDN Magazine December 2002

XSL Transformations: XSLT Alleviates XML Schema Incompatibility Headaches


The XSL Transformations (XSLT) specification defines an XML-based language for expressing transformation rules that map one XML document to another. XSLT has many of the constructs found in traditional programming languages, including variables, functions, iteration, and conditional statements. In this article you'll learn how to use the XSLT instructions and template rules, manage namespaces, control transformation output, use multiple stylesheets, and employ pattern-matching with template rules. A sidebar explains how to access XSLT from MSXML using the IXSLTemplate and IXSLProcessor interfaces.

Don Box, Aaron Skonnard, John Lam

MSDN Magazine August 2000

SQL/MTS: Automating the Creation of COM+ Components for a Database Schema


Using Microsoft Windows DNA architecture as a guideline, it's possible to create scalable multitier database applications with COM+ and Microsoft Transaction Services. In fact, you can use existing table definitions to automatically build the MTS/COM+ business logic layer and data access components for your application. This article will walk you through the development of database transactions by mapping the transactions to automatically generated MTS/COM+ components. This technique can greatly simplify the task of creating components for a large project.

Aleksandr Mikunov

MSDN Magazine July 2000

Replicating the Keyword match feature from Google GSA



We are trying to replicate a feature in sharepoint search that the Google Search Appliance has called "Keyword Match".  You choose a keyword or phrase and map it to a url.  When a user searches with that keyword or phrase the result link that you've matched it to comes up first in the list of results.  I'm trying to find a similar feature like this in Sharepoint OOTB search web parts.  Can you advise?  Thank you!

Mark De Souza

Preventing Manual DataBindings from Being Stupid...

Okay, This is rather annoying, but the basic situation is that using the Control.DataBindings() collection is often VERY simple easy and effective.  However, there are circumstances that require tweaking. Case and point: Application Settings via the My.Settings class structure.  Now, I have a "Preferences" form which upon the load of my application the first time, it requires the user set certain settings (and will cancel out of the app if the aren't defined on the first load).  All of this works fine, but I have a minor little glitch revolving around the Binding.Parse event and the Binding.WriteValue() method. Basically, when the Preferences form loads, all the controls that are bound to a My.Settings property, are set to DataSourceUpdateMode.Never.  In the Form.Load event, I execute a Control.DataBindings(0).ReadValue() on each of the controls that are bound.  This propagates the form with the appropriate values from the My.Settings Class.  Now the user changes/edits/modifies etcetera the values of the controls on the form, and based upon the appropriate values the OK Button will become enabled. Two of the values are "Folder Locations" but are uniquely formatted in my case, using a "special folder" moniker, for Desktop, or My Documents, etc, etc, etc, so if the user browses for a folder or types one in manually, m

.net 4.0 machine.config schema?

Where can I find the official schema for .NET 4.0 machine.config?   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