Month: November 2012

Issue: Length of LOB data to be replicated exceeds configured maximum 65536

Rizwan Ahmed Uncategorized ,

Error:

Length of LOB data (78862) to be replicated exceeds configured maximum 65536

Scenario:

We published some articles that use varchar(max) and a lot of XML data types for the columns. When we enabled replication, we got the error Length of LOB data (78862) to be replicated exceeds configured maximum 65536

Solution:

Increase the size that can be replicated. This is applicable for transactional replication only.

T-SQL:  EXEC sp_configure ‘max text repl size’, 2147483647

SSMS (excerpt from BOL):

    1. In Object Explorer, right-click a server and select Properties.
    2. Click the Advanced node.
    3. Under Miscellaneous, change the Max Text Replication Size option to the desired value.

Reference:

BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3056cf64-621d-4996-9162-3913f6bc6d5b.htm

Taken from: http://sqlmusings.wordpress.com/2008/09/22/issue-length-of-lob-data-to-be-replicated-exceeds-configured-maximum-65536/

Advertisement

70-480: Programming in HTML5 with JavaScript and CSS3 – Done

Rizwan Ahmed Certifications, HTML5 , , , , , ,

Hi,

Today, I took the 70-480: Programming in HTML5 with JavaScript and CSS3 – and cleared it. I thought it would be easy one, but it wasn’t – it had more than expected material coverage. As I can’t give specific details out, so I will make it short and general.

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-480

  1. Study the Channel 9, Screencast from http://www.microsoftvirtualacademy.com/tracks/developing-html5-apps-jump-start
  2. Study HTML5 from Pluralsight
  3. JavaScript Inheritance, Anonymous methods
  4. Structuring JavaScript Code
  5. Exception Handling
  6. Ajax – JQuery
  7. Event Handling
  8. Binding Events
  9. CSS3, Padding
  10. Positioning in CSS
  11. Header, Aside, Semantics

I had very cool experience with the javascript, html and dhtml etc … so I got it through. But you should have some experience and had actually build some stuff with html/ html5/ javascript and jquery.

Having experience helps a lot.

Thanks,

Riz