better option for me would be to use a small powershell script to download the contents and load directly to sql server.

edit: the original link only extracts current year -...

• This reply was modified 3 years, 10 months ago by frederico_fonseca.

kindly supply table and indexed DDL for all tables involved as well as row count for each table - and at same time do tell us why table TPartFeature does...

ssms is not BCP - and what you get on SSMS is in many cases totally out of sync with what  you get with other tools.

on this case SSMs applies...

your expectation may not be what you can generate from sql using BCP - not knowing what options you are using I would advise using

"-c" which will add a \r\n...

why don't you wish to use stuff?

you can use substring - but that will make your code a bit more complex.

on diff note - avoid hardcoding dbnames (use synonyms instead)...

To add to what Jeffrey said - if a CTE is mentioned in the following code 2 or more times it's evaluated and executed as many times. No...

the issue is not the sql itself but the whole combination - your system is likely constrained in memory and was unable to produce a plan for the full query.

the...

Of course it must vs taking locks.

"and use snapshot isolation."  MEGA-HUGE overhead.  SI should only be used...

you don't change the connection manager - you change the connection string that the connection manager uses.

only case where this is not possible is when your connection is a flat...

ahhhh. numbers....

2 situations - long ago, still on mainframes.

some reports were based on Lines of Code written.. so 2 teams each with their own type of code managed to "improve"...

error is very clear - that user (bit\pqScott) does not have permissions to create the table on database RRDB01 - fix the permissions as required.

that has happened often enough over last few years - and not only with that CU - some of the scripts that are part of the upgrade process are not...

What...

Hold on.  I explicitly stated that auditors should not be able to change anything on the system.  Talking about giving auditors "sysadmin" is a straw man.

Scripts that capture full permissions...

And in neither case did all inquiries go thru and be approved by the DBA, correct?

An "audit" that only allows what the DBA wants to run is not a...