Turns out they came from Visual Studio 2015 when defining an SSIS Data Source as a Project Data Source.

We created a pattern where setting up Always On was done with a remote login of a windows service account. It took care of a lot of problems.

for SSRS 2016 -- 

Agreed with the header and footer skewing the Excel column creation.

• Start out with just the table(s). Get rid of...

These are both really good. Will discuss with my Release Manager and my Architect which direction.
Thanks very much.
Andre

Sue,

Thanks for your reply.

I've looked through various RS.EXE web pages and I don't see examples on how to create a new Data Source with credentials...

when I tried to run the code in Powershell, I got the following error.

[font="Courier New"]Import-Module : The specified module 'ActiveDirectory' was not loaded because no valid module file was found...

We'd use a not dissimilar approach for creating test data and removing sensitive data when copying from production to development. Each of the tables had a corresponding table in a...

Yeah, I found a lot more since I first posted. For example, from the master server:

selectserver_name, *

frommsdb.dbo.systargetservers

or this, to help identify target servers that are failing:

-- http://mikehillwig.com/tag/multi-server-administration/

create table #tmp_sp_help_targetserver(

server_id int...

You're right. I should have expanded on this. The archive data would be exported to a database on another server. If that is not possible, then an export to a...

You may also free up some space with a more aggressive archiving approach to your data, or install archiving at all.

I've seen a number of legacy systems have up 10...

I've had much better luck historically by creating a [font="Courier New"]#TempTable[/font] with a [font="Courier New"]Done = cast(0 as bit)[/font] extra column.

That way I can review the results at the end...

I didn't have any success with Adam Haines' approach. When trying to test this I got the error:

[font="Courier New"]The specified schema name "dbo" either does not exist or you do...

I very much appreciated the connection and feedback about Rob's article. I have felt that way at times, too, but never really had the means to discuss my REALLY strong...

This was some great code, Jack. Much of it is working well. However, the cdc_DBName_capture job is taking a heck of a long time. It needs about 18 hours of...