SQL Server 2008 Operator Email Name length : Max Characters | Email addresses

Question

In SQL Server 2008, if one would want multiple email addresses to be notified when a Job Succeeds or Fails, he would have to Assign Email notification to an Operator in Job Properties -> Notifications.

In my case, due to email domain length, I can only enter 3 email address in Operator's "Email Name" Field.

Is there any way out so that i can allow notification to 3+ email addresses?

Note : An option to assign multiple operator to a Job notification also would do.

Community · Accepted Answer · 2017-05-23 12:05:09Z

2

Only up to 128 characters. This is the max length of the sysname datatype

See:

SQL Server: Maximum character length of object names

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Apr 17, 2014 at 10:07

divan

292 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Frank Goortani · Accepted Answer · 2014-09-19 19:40:18Z

The Email Name length in SQL Server 2008 R2 is 100 characters. The problem is that if you type a longer value it will cut it.

Collectives™ on Stack Overflow

SQL Server 2008 Operator Email Name length : Max Characters | Email addresses

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related