Doing some breakdown tests now. There is nothing wrong with the underlying data. It works fine if I limit the result set to x million rows. I`m guessing that we...

Script falls over here -

-- Adding the transactional publication

use [Gather]

exec sp_addpublication @publication = N'GatherReportingReplication', @description = N'Transactional publication of database ''Gather'' from Publisher ''PRODCLUSTER2''.', @sync_method = N'concurrent', @retention =...

Something odd is going on as it won`t even let me script it. The script button is greyed out.

That query returns nothing, I have checked several times and those data types do not exist in the DB.

The connection string logon has its default database set to the database in question.

It almost feels like it losing that connection string and then revering back to the users own...

Apologies - this is in the wrong forum.

I can`t move it so feel free to ignore this one.

As an update.

I have found this program - https://www.stattransfer.com/index.html

Only a couple of hundred dollars and looks to be exactly what I need to transfer data into the...