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

use $($variablename) to see if it solves your issue.

As to password protected spreadsheets, I've not had to work on such things before.  I'll have to do a test to find out if the "ACE Drivers" have a...