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, 2 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...

https://docs.microsoft.com/en-us/ef/core/modeling/entity-properties

Reading through that it sounds to me like EF doesn't support excluding columns when reading the database side of things BUT quick googles indicate that you can exclude a column...

I expect that is possible, but it would be messy to do and error prone and I expect difficult to maintain.

When doing changes like this, my preference is to make...

My guess with this is not a problem with the stored procedure naming but more with your permissions.

I just executed the following against a SQL Server 2016 instance and it...

This is a double post.  Did none of the answers in the previous thread help?

The query is identical...

Link:

https://www.sqlservercentral.com/forums/topic/need-help-with-sql-code

I think the first step to troubleshooting this is knowing what error you get.  Is it that it doesn't like your username/password or is it a TCP/IP error or a...

I am guessing you mean a SQL Server service pack update, right?

If so, have you tried going to the folder it extracted the data to and looking for a "setup.exe"...

A test environment is good for this and for other things too.

If you want to deploy a report for an end user to test (for example), this works great! Or...

As to what is in the logs, that I am not sure.  I don't know what specific error messages will pop up, but the log will tell you exactly what...