Doh!  As soon as I read your comment, I'm smacking my hand against my head.  I think I need to go eat something and take a breather before I look...

Yeah, that code does work.  I know it does.  My question is why that works and the simple version without a temp table doesn't work.

What do you get when you...

• This reply was modified 1 year, 11 months ago by  DBAless.

My setting is set to over 65,000 characters.

I did try your xml method and it truncated in exactly the same place.

Can you elaborate?

• This reply was modified 1 year, 11 months ago by  DBAless.

David,

I understand the issues with SMTP servers and I would heavily pursue your line of thinking IF the emails had shown up in msdb.dbo.sysmail_allitems with any kind of status.   Or...

• This reply was modified 3 years, 3 months ago by  DBAless.
• This reply was modified 3 years, 3 months ago by  DBAless.
• This reply was modified 3 years, 3 months ago by  DBAless.
• This reply was modified 3 years, 3 months ago by  DBAless.
• This reply was modified 3 years, 3 months ago by  DBAless.
• This reply was modified 3 years, 3 months ago by  DBAless.

David,

The emails are all internal.

Can you be more specific about what kind of SMTP error could cause DBMail to not log any errors?

Johan,

In my original description I outlined how I...

• This reply was modified 3 years, 3 months ago by  DBAless.

Thank you.  I see how my math went wrong now on the conversion to GB.

Also, I've realized my assumptions were off.  When I originally setup the tempdb into 8 files,...

For example, the MS site says you can run this

SELECT SUM(unallocated_extent_page_count) AS [free pages],

(SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]

FROM tempdb.sys.dm_db_file_space_usage;

But I get these results which make even less sense

Free Pages...

• This reply was modified 4 years, 6 months ago by  DBAless.
• This reply was modified 4 years, 6 months ago by  DBAless.

Yes, that's what I've seen on the internet.  But I don't believe I have that much space in reality.  To convert to GB you would divide by 256, right?

Yeah, I have several habits I'll have to adjust when we upgrade from SQL Server 2014.  Of course, the vendor application I'm "tweaking" has a ton of old code like...