Ttdfjt

How to investigate an unknown 1.5GB file named "sudo" in my Linux home directory?

Why does Sauron not permit his followers to use his name?

Is this position a forced win for Black after move 14?

Shall I fix cracks on bathtub and how to fix them?

How did medieval manors handle population growth? Was there room for more fields to be ploughed?

Why can't you say don't instead of won't?

Normalized Malbolge to Malbolge translator

Why nature prefers simultaneous events?

Is Nikon D500 a good fit for nature and ambient-lighting portraits and occasional other uses?

What's the point of fighting monsters in Zelda BotW?

Why does `buck` mean `step-down`?

Why is "I let him to sleep" incorrect (or is it)?

Do application leftovers have any impact on performance?

Alternatives to Network Backup

Did ancient peoples ever hide their treasure behind puzzles?

Notice period 60 days but I need to join in 45 days

Is there an in-universe explanation given to the senior Imperial Navy Officers as to why Darth Vader serves Emperor Palpatine?

Board Chinese train at a different station (on-route)

What checks exist against overuse of presidential pardons in the USA?

What is the sound/audio equivalent of "unsightly"?

Inspiration for failed idea?

Is there a word or phrase that means "use other people's wifi or Internet service without consent"?

Don't look at what I did there

Can two aircraft stay on the same runway at the same time?

Generating Error when data size is larger then max text repl size

Length of LOB data (%1) to be replicated exceeds configured maximum %2Reattaching MDF files recovered from RAID 5Length of LOB data (2135980) to be replicated exceeds configured maximum 65536What is the impact of setting “max text repl size (B)” to -1?How to fix an odd LSBackup job error in Log Shipping?Empty blocking process in blocked process reportHow to make cdc skip the point that it is stuck at?Questions on Availability Group Readable SecondaryCDC error - Error converting data type varchar to uniqueidentifierCannot connect to <instance>. A severe error occurred on the current command

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

4

I recently ran into an issue with where an application tried to do an insert with data over the max text repl size. this time the failed insert was captured by the application log, and I was made aware. I was a little disturbed though to find out the error wasn't captured in the sql server error log, and I don't see it captured any place else.

Any advise on how to capture, and Ideally generate alerts based on the 'Length of LOB data (XXXXXX) to be replicated exceeds configured maximum " would be appreciated.

sql-server replication

share|improve this question

asked Aug 16 at 17:12

PatrickPatrick

41144 silver badges1414 bronze badges

add a comment | 

4

I recently ran into an issue with where an application tried to do an insert with data over the max text repl size. this time the failed insert was captured by the application log, and I was made aware. I was a little disturbed though to find out the error wasn't captured in the sql server error log, and I don't see it captured any place else.

Any advise on how to capture, and Ideally generate alerts based on the 'Length of LOB data (XXXXXX) to be replicated exceeds configured maximum " would be appreciated.

sql-server replication

share|improve this question

asked Aug 16 at 17:12

PatrickPatrick

41144 silver badges1414 bronze badges

add a comment | 

I recently ran into an issue with where an application tried to do an insert with data over the max text repl size. this time the failed insert was captured by the application log, and I was made aware. I was a little disturbed though to find out the error wasn't captured in the sql server error log, and I don't see it captured any place else.

Any advise on how to capture, and Ideally generate alerts based on the 'Length of LOB data (XXXXXX) to be replicated exceeds configured maximum " would be appreciated.

sql-server replication

share|improve this question

asked Aug 16 at 17:12

PatrickPatrick

41144 silver badges1414 bronze badges

share|improve this question

asked Aug 16 at 17:12

PatrickPatrick

41144 silver badges1414 bronze badges

share|improve this question

asked Aug 16 at 17:12

PatrickPatrick

41144 silver badges1414 bronze badges

asked Aug 16 at 17:12

PatrickPatrick

41144 silver badges1414 bronze badges

asked Aug 16 at 17:12

PatrickPatrick

41144 silver badges1414 bronze badges

1 Answer
1

active

oldest

votes

4

The SQL Server error log only captures errors having a significant severity (generally 19-25, with exceptions). See the documentation here:

• 
  https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-error-severities

Imagine if all divide by zero, ambiguous column, or syntax errors flooded the error log? That log would quickly become an unmanageable mess.

What you can do is use an Alert, which can trigger notifications and other actions whenever an exception with a certain severity (or, in your case, error number) is raised:

• https://docs.microsoft.com/en-us/sql/ssms/agent/alerts

For example:

EXEC sys.sp_add_alert @name = 'repl size error',
 @message_id = 7139, -- I believe this is the right message
 ...

See this doc for sp_add_alert usage:

• https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-alert-transact-sql

share|improve this answer

answered Aug 16 at 17:27

Aaron Bertrand♦Aaron Bertrand

160k1919 gold badges316316 silver badges523523 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, I didn't capture the message number and I wasn't finding a specific message number when looking online. Thanks a lot
  
  – Patrick
  Aug 16 at 17:36
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Patrick FWIW I don't have it memorized either, I found it by something along the lines of SELECT * FROM sys.messages WHERE [text] LIKE N'%repl%size%';
  
  – Aaron Bertrand♦
  Aug 16 at 19:09
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f245549%2fgenerating-error-when-data-size-is-larger-then-max-text-repl-size%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

4

The SQL Server error log only captures errors having a significant severity (generally 19-25, with exceptions). See the documentation here:

• 
  https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-error-severities

Imagine if all divide by zero, ambiguous column, or syntax errors flooded the error log? That log would quickly become an unmanageable mess.

What you can do is use an Alert, which can trigger notifications and other actions whenever an exception with a certain severity (or, in your case, error number) is raised:

• https://docs.microsoft.com/en-us/sql/ssms/agent/alerts

For example:

EXEC sys.sp_add_alert @name = 'repl size error',
 @message_id = 7139, -- I believe this is the right message
 ...

See this doc for sp_add_alert usage:

• https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-alert-transact-sql

share|improve this answer

answered Aug 16 at 17:27

Aaron Bertrand♦Aaron Bertrand

160k1919 gold badges316316 silver badges523523 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, I didn't capture the message number and I wasn't finding a specific message number when looking online. Thanks a lot
  
  – Patrick
  Aug 16 at 17:36
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Patrick FWIW I don't have it memorized either, I found it by something along the lines of SELECT * FROM sys.messages WHERE [text] LIKE N'%repl%size%';
  
  – Aaron Bertrand♦
  Aug 16 at 19:09
  
  

  
  
  
  

add a comment | 

4

The SQL Server error log only captures errors having a significant severity (generally 19-25, with exceptions). See the documentation here:

• 
  https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-error-severities

Imagine if all divide by zero, ambiguous column, or syntax errors flooded the error log? That log would quickly become an unmanageable mess.

What you can do is use an Alert, which can trigger notifications and other actions whenever an exception with a certain severity (or, in your case, error number) is raised:

• https://docs.microsoft.com/en-us/sql/ssms/agent/alerts

For example:

EXEC sys.sp_add_alert @name = 'repl size error',
 @message_id = 7139, -- I believe this is the right message
 ...

See this doc for sp_add_alert usage:

• https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-alert-transact-sql

share|improve this answer

answered Aug 16 at 17:27

Aaron Bertrand♦Aaron Bertrand

160k1919 gold badges316316 silver badges523523 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks, I didn't capture the message number and I wasn't finding a specific message number when looking online. Thanks a lot
  
  – Patrick
  Aug 16 at 17:36
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Patrick FWIW I don't have it memorized either, I found it by something along the lines of SELECT * FROM sys.messages WHERE [text] LIKE N'%repl%size%';
  
  – Aaron Bertrand♦
  Aug 16 at 19:09
  
  

  
  
  
  

add a comment | 

The SQL Server error log only captures errors having a significant severity (generally 19-25, with exceptions). See the documentation here:

• 
  https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-error-severities

Imagine if all divide by zero, ambiguous column, or syntax errors flooded the error log? That log would quickly become an unmanageable mess.

What you can do is use an Alert, which can trigger notifications and other actions whenever an exception with a certain severity (or, in your case, error number) is raised:

• https://docs.microsoft.com/en-us/sql/ssms/agent/alerts

For example:

EXEC sys.sp_add_alert @name = 'repl size error',
 @message_id = 7139, -- I believe this is the right message
 ...

See this doc for sp_add_alert usage:

• https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-alert-transact-sql

share|improve this answer

answered Aug 16 at 17:27

Aaron Bertrand♦Aaron Bertrand

160k1919 gold badges316316 silver badges523523 bronze badges

EXEC sys.sp_add_alert @name = 'repl size error',
 @message_id = 7139, -- I believe this is the right message
 ...

share|improve this answer

answered Aug 16 at 17:27

Aaron Bertrand♦Aaron Bertrand

160k1919 gold badges316316 silver badges523523 bronze badges

answered Aug 16 at 17:27

Aaron Bertrand♦Aaron Bertrand

160k1919 gold badges316316 silver badges523523 bronze badges

answered Aug 16 at 17:27

Aaron Bertrand♦Aaron Bertrand

160k1919 gold badges316316 silver badges523523 bronze badges