Just completed my response but posting resulted in an "error" here on the board. 🙁

Will type it together again, may take some minutes though

Frank

Replica SecondaryRoleConnections ReadonlyRoutingUrl

[SQL-01] ...

Hi again, have been away a few days.

bcp "table" out nul -n -S192.168.100.230,1433 -T -dTEST -a8000

should direct the data output to nul, right?

Today I have repeated the full test harness...

forgot to mention .. there is no encryption set up in any way, neither on network level nor TDE nor anything else.

Hi Erland, thanks for your thoughts. That was actually my first reaction: let's run the same bcp command on the server itself.

The effect is: BCP defaults to Shared Memory...

You mean execute this query by means of sp_msforeachdb ?

Thanks for the article. 🙂 However, I am using Xsl transformations, Levenshtein, Regex Functions since SQL 2005 came out through my own CLR assembly. I would not migrate...

Hi, reading your article I have stumbled across a few more points:

Under "Selecting columns to give an index" you say

Putting a Primary Key on a column has the effect of...

Hi, very nice article. I am currently - enough spare time permitted - experimenting on a similar setup, just using Hyper-V and a Synology NAS System (DS1511).

Just a few comments/questions:

-...