That's the most likely answer. Test SQL Browser connectivity with PortQry on UDP 1434.

It shouldn't, but it won't do any harm if you're listening on all addresses.

SSIS seems to me overkill for just checking a file exists.

Powershell can do that:

$ErrorActionPreference = "Stop"

if( -not (Test-Path "c:\temp\im_not_there.txt")) { throw "Not there!" }

CMD can do that as well

if not...

Remove the settings from that address and configure IpAll.

You should be fine.

Jeff, point taken. Thanks for the performance test.

Eirikur Eiriksson (1/25/2016)

spaghettidba (1/25/2016)

It is a CLR function, so there's...

It is a CLR function, so there's a startup cost...

SQL Server 2012 supports the FORMAT function:

select format(GETDATE(), 'dd-MMM-YYYY')

Looks like a client-side issue.

What is probably happening is something along these lines:

The connection pool is initialized with a number of connections, then for some reason it loses connectivity...

In my opinion you shouldn't be doing an in-place upgrade. It almost always turn out to be ugly. Do a side-by-side...

You could read the file in a variable and concatenate it to the message body:

DECLARE @body NVARCHAR(MAX)

SELECT @body = BulkColumn FROM OPENROWSET (BULK 'G:\MySalesReport.htm', SINGLE_BLOB) a

EXEC msdb.dbo.sp_send_dbmail

@profile_name =...

Link please?

Jacob Wilkins (1/20/2016)

I seem to...

Trace flag. Add "-T272" to your SQL Server startup parameters or enable it globally before adding to the startup params:

DBCC TRACEON(272,-1)

Indeed the default identity preallocation is 1000, 10K looks suspicious. Try enabling TF 272 (it disables identity preallocation) and see if it makes a difference.