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, 6 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, 6 months ago by Mr. Brian Gale. Reason: Code update
• This reply was modified 5 years, 6 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...

What I would strongly encourage you to do is get a test instance set up so you can try out the different methods suggested.  The main reason to get a...

So was able to replicate the issue!

My steps were to first create the database, create the stored procedure named mmytest.  Next, changed Page Verify to NONE, took...

These are not...

Ok I am completely stumped on this one. I was trying to re-create the object using different flavors of dynamic SQL and casting and converting hoping I could trick SQL...

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

To add to what Phil said, the error you got seems to indicate the problem:

Bulk load failed due to invalid column value in CSV data file Jobs.txt in row 477,...

Oh that is a challenging one then.  I was just trying to figure out how to reproduce that.

As a thought, I am wondering if there might be some character before...

Just so I understand things right, you are asking if you can filter the rows from table A that are replicated based on specific criteria?  if so, this is entirely...