whenever I see these errors on BCP its one of the following

• invalid CSV file - e.g. not Double quoted on "fields" that contains double quotes or CR or LF

...

have a look at the code below.

basically I've created a temp table (on your case it would be a Permanente one) staging table to load the raw data

these types of...

replace the strings and values with others - as long as the position and sizes are the same it will do - without it not much we can tell.

but regardless...

a text file would never look like that - that has formatting that would not be possible on a text file so you are showing us potentially a rendering of...

Also, if the %of duplicates is higher than the % of singles, then it may be better to copy the singles into a new table and switch out...

have you read the manual?

you already have the sql to execute - you just need to copy and paste the 2 lines and reduce the size accordingly yourself

you were given options and directions on your prior post - what did you do with it and if you did try it what was the result?

https://www.sqlservercentral.com/forums/topic/shrinkfile-option-not-working

and shrinkdatabase is not...

that is a SQL issue - not VS or Schema compare issue.

basically server needs more memory or needs to have less memory allocated to SQL Server - other processes running...

WOW, Frederico, YYY999 as variable names. Yes, at least "VSC" did make sense, given that we worked with a data that was called "Voucher Service Code". The naming convention...

I totally agree, Louis! Once I had a coworker who hated naming anything like VoucherServiceCode. She insisted that all columns in tables had to be abbreviated, so in this...

Why are you duplicating this question? I don't see a link suggesting this is spam, but the answers to that almost identical question are going to be...

error message is very clear - a attempt was done to login to the server with a connection string that is a AD account, but trying to connect as if...

not sure if a TVF would solve this - still worth a try. but try both ways.

regarding the images - I use Plan Explorer from SQLSentry - https://www.sentryone.com/about-us/news/sql-sentry-plan-explorer-free-for-all-users

it is a...

so.. the plan you supplied does not have the MAD percentages / row counts - but it does show, very clearly in my opinion, the issues you have.

So your understanding...