It looks as though you want to export blobs. I would do this quickly with powershell, something like:

https://andyspecht.github.io/2017-06-23-extracting-images/

Thanks Sue. This sound like a good idea; I will look into it.

Thanks for the information.
I already have agent alerts for errors 823, 824, 825 and 832 but regularly checking suspect_pages is a good idea I will look at.
My experience...

Are you using four part naming in the view? If you are then all the rows for the remote table will be returned before filters are applied.
You might be...

I think BCP needs a format file for this.

I  tend to use Powershell for this type of processing with the Out-DataTable function:

https://gallery.technet.microsoft.com/scriptcenter/4208a159-a52e-4b99-83d4-8048468d29dd

I then ...

I have recently been moving a lot of DBs to SQL2017 and doing an intial check with the Data Migration Assistant.
It produces the following warning with the old join...

Here is the last of a series of article by Kathi Kellenberger which quickly explains the basics of SSRS.
Start by reading  Part1 and Part4.

https://www.red-gate.com/simple-talk/sql/reporting-services/sql-server-reporting-services-basics-deploying-reports/

SELECT '07-11-18', CONVERT(date, '07-11-18', 5)

We are currently in the process of removing our SQL2008 instances before they go out of extended support next July.

Most of the DBs will be moved to SQL2017...

I am not quite sure what you are doing but the following may help.

-- *** Test Data ***
CREATE TABLE #t
(
    quantity_text varchar(255) NOT NULL
);
INSERT...

I would start with something simple like:

SELECT DISTINCT
    P.state_desc COLLATE DATABASE_DEFAULT + ' '
    + P.[permission_name] COLLATE DATABASE_DEFAULT + ' TO '
    + R.[name] COLLATE DATABASE_DEFAULT + ';'

Just remember that you might not be the only person taking backups.
eg Your systems team might be taking VSS backups which could be differential as well as full.
You...