I logged in and saw the league just fine this week

I haven't seen a server come back because of thread exhaustion, but that may have been the business (or my own) lack of patience to wait and more willing to...

About a 3 hour delay Fri for me, mostly due to a slow flight getting to Austin to take me home.

Yesterday, no real delays for UAL in Denver related.

I think...

Same, but I suspect most political stuff is driven by money for a few people (the top 5%, big companies, politicians of all kinds), so they don't want to press...

Can you build a DSN That points here and connect? Something like: https://support.microsoft.com/en-us/office/administer-odbc-data-sources-b19f856b-5b9b-48c9-8b93-07484bfab5a7

I assume then you followed this: https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-odbc-generic?view=sql-server-ver16

I'd say you need:

EXEC sp_msforeachdb  'use ? SELECT ''?'', definition FROM sys.all_sql_modules WHERE definition LIKE ''%xp_cmdshell%'';'
GO

USE msdb
GO
SELECT s2.job_id, s2.name, s.step_name FROM dbo.sysjobsteps AS s INNER JOIN...

• This reply was modified 1 years, 7 months ago by Steve Jones - SSC Editor.

Crazy, I was lightly worried Fri as I was traveling as well. No reported issues until we got to the airport (about 90 minutes before the flight) and got a...

I think the advice above is sound (sorry for the delay).

If you rewrite, I would look at a cloud based db, though mostly because of latency. If you stick close...

I tend to follow's Brian's methodology ^^

You haven't made this easy. The data you provided is in a text format for humans, not a format that makes it easy to load. We, or at least I,...

You don't seem to want to do work on your side. The data you provided isn't something I can easily run. It's just data.

I am happy to try and help,...

The job runs as a particular login. Change the login under which the job runs.

Hmmm, Jeff going. I'm going to have to see if I can make it.

I don't know of anything, as mapping data in a db and ensuring it's not missing something or removing something needed, is a complex problem.

Most people do this with simple...

Not sure. what I would suggest is you mock this up with data that helps debug what's happening and break apart the query. Likely this is data driven in some...