Can this be done? I just want all database objects to be pushed out to a subscriber once a week via snapshot replication. Procs, tables, triggers, functions etc but I dont want any of the table data
Thanks in advance
View Complete Post
I have a problem with geography data type replication. Any change that is done on a Geography column breaks the replication - the error message is "The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the
article at the Subscriber." I double checked compatibility settings that is suggested here:
http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d8e31621-5d43-48cd-bdd3-c02b8a24625c. But both publisher and subscriber are 100RTM.
I checked synchronization logs and found a strange message - attempt to convert varchar to geography. I don't understand from where the varchar data type comes from. Tables at subscriber and publisher has the same format - geometry stored in geography data
2010-09-20 18:36:22.499 The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart
the Merge Agent to apply the DDL changes and synchronize the subscription.
2010-09-20 18:36:22.845 Category:NULL
Source: Merge Replication Provider
I have a data table that contains some values for Certifications. This table can be updated in a different part of my application. On the web page I am currently working on, I would like to have check boxes appear for every value in the data table. I have been struggling with this trying to use a For Each loop and I cannot get it to work for anything. Any suggestions?
I am using the following Razor syntax to obtain my data (I know this works because I can display it in a WebGrid):
var db = Database.Open("MyConn");
I need to know how to show top 30 records from four table
with fastest speed.. in ms sql server 2005..
hope You do the needfull
Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.
MSDN Magazine August 2010
Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she's done the hard work to grasp the new concepts and help you get up to speed.
MSDN Magazine July 2010
In this article, the author shows you three new arrivals on the SQL Server spatial visualization scene: the map control in SQL Server 2008 R2 Reporting Services (SSRS), the ESRI MapIt product, and the MapPoint Add-In for SQL Server 2008.
MSDN Magazine November 2009
After a brief refresher on procedural and object based patterns for organizing the business logic layer, the author focuses on data transfer objects and the impact they have on the development of the software project.
MSDN Magazine August 2009
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.
MSDN Magazine February 2009
In T-SQL, views and derived tables serve similar purposes and have their advantages. But when working with SQL Server 2005,there's a third option--using Common Table Expressions (CTEs). John Papa explains.
MSDN Magazine October 2007
SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.
MSDN Magazine June 2007
In this column see how to bind a custom list of business entities using the binding tools in the .NET Framework 2.0.
MSDN Magazine February 2007
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.
MSDN Magazine November 2004
Dealing with error handling between T-SQL and a calling application, evaluating when a field's value has changed, and creating auditing tables in SQL ServerT are all common issues that developers must tackle.
MSDN Magazine April 2004
Edited by Nancy Michell
MSDN Magazine October 2003
MSDN Magazine September 2003