A bit of background. We developed an app that uses merge replication. Right now, we are currently publishing about 212 articles, and everything is fine, as it appears to fall into the 256 article count limit. (Using SQL Standard 2005 at the server, and 2005 Express at the subscriber level.)
We are in the process of developing a new version, with a new database built from the ground up, which will have a minimum system requirement of SQL 2008 R2 Standard server side and Express 2008 R2 at the client end, which also appears to have the same 256 count limit on published articles. (yes, we will also support 2012, it's limits are the same though)
The question comes in where we have successfully test published out over 400 articles in the new version, and everything tests functionally (pub creation, snapshot and subscriber creation, and replication itself). Has anyone else exceeded the count limit before, and is this just a soft recommended limit? We have not seen any errors, either during publication creation, or subscriber creation.
According to this article: http://msdn.microsoft.com/en-us/library/ms143432%28v=sql.105%29
I'm waiting on a call back from Microsoft, but I'd like to know if anyone has seen this before, in any ver of SQL.
Best Answer
I have now Merge replication setup with 666 Table Articles in production, and I didn't get any warning or errors regarding articles limit.
Update: Starting from SQL Server 2016, Articles limit is now: 2048
Source