I think you are mixing some things up and getting confused.  A LOGIN FAILED message in the log means that a login was attempted but was not successful.  The CLIENT...

That bit of code looks fine to me.  What I'd recommend is posting an execution plan.  That will likely be the best bet to figure out why it is slow.

How...

Another reason for SQL Server Agent issues is if you are running SQL Express.  SQL Express doesn't support SQL Agent.

But, as John Mitchell suggests, check the logs.  Also, check the...

the users in a database are contained in the single database.  There is no way (that I know of) to get all of the users in a database without using...

I think that won't work unfortunately.  SQL is being helpful and pulling the data out of master when you query against sys.sql_logins.  You can verify this by switching to any...

Could you post the exact error message?

I have links all over the place with different SQL versions (ranging from 2008 R2 to 2016) and everything seems to work without  much...

I went a slightly different route... I used Jeff Moden's DelimitedSplit8K function to do this...  (some of the bits are just intermediary calculations)

SELECT ft.RawValue
, ca.ItemNumber
,...

Glad you tackled one problem.  Too bad it created a new one.

If memory serves, SOS_SCHEDULER_YIELD is related to CPU utilization and may be safe to ignore.  A good writeup on...

How to contact them for support depends on your support contract with your license (I believe).

I would reach out to the license vendor first, and failing that this link has...

Ok, was reading through this blog:

https://www.mssqltips.com/sqlservertip/5858/how-to-remove-filestream-from-a-sql-server-database/

and my understanding of filestream was off.  But came up with a thought - Do you get any results when you run this query:

            
June 29, 2020 at 7:09 pm
            
#3766272

            
            
                                                
        

Yeah, I'm a bit curious as well.

The error about version mismatches makes me think that the SQL instance was patched, but that the ISDBUpgradeWizard was not.  Are there outstanding SQL...

My only question with this is a pretty easy one - should your calculation to calculate the Forecast/RR for future months be per-customer, per Cost_Centre, or only look at the...

This may be a silly question but did you install the 2019 SSIS along with the 2019 SQL Instance?

Next, does the following path exist:

D:\Program Files\Microsoft SQL Server\150\DTS\Binn\ISDBUpgradeWizard,

Those would be the...

• This reply was modified 5 years, 2 months ago by Mr. Brian Gale.

I just wanted to confirm an assumption I had prior to working on this - the TextUnit value will never change in a "Value", correct?  Plus, is the "TextUnit" value...

• This reply was modified 5 years, 2 months ago by Mr. Brian Gale. Reason: Code update
• This reply was modified 5 years, 2 months ago by Mr. Brian Gale. Reason: removed the USE statement as it likley doesn't apply in your case

Do you use FILESTREAM at all?  If not, it may be safe to just turn the option off at the instance level or configure it to be "blank" at the...