I'm guessing at why you want to do this and from my guess I say "don't do it". Tell me why you want to do this and I might...

Go ahead and add the index. If you do ever have a support call with Microsoft you drop the index.

DECLARE @DateStr VARCHAR(12);

SET @DateStr = REPLACE(CONVERT(VARCHAR(12), GETDATE(),102),'.','');

DECLARE @cmd VARCHAR(2048)

SET @cmd = 'bcp "EXEC SigHealth..spAPSDownload_Lab" queryout'

+' "\\sh-sftp\data$\aps_billing\APS_Lab_'+@DateStr+'.TXT" -c -T -t^|'

...

I don't disagree with the comment about the double negatives.

I'm a fan of the Redgate SQL Comparison tools. They've helped me a few times in the past with tricky situations.

Do you have Visual Studio? I've...

I'd be impressed if you replied along the lines of SQL being a...

Yes, in the Flat File Connection Manager set a value of " for the Text Qualifier.

I'd also be kicking the butt of whoever accepted this into service without doing any type of BC/DR testing (including restoring the database from a full backup). And 1200...

You can use RESTORE FILELISTONLY with the path to the backup file and then use the information returned to build your restore script using the WITH MOVE options if the...

The column separator can only be a single character.

https://msdn.microsoft.com/en-us/library/ms162773(v=sql.110).aspx

Could you use BCP instead?

Is this the same behaviour for table variables? Or are there any differences/gotchas to be aware of?

Oh, I forgot, I've used it to do SAN based snapshot backups as well! 🙂

I've used powershell to script out all the SQL Server Agent Jobs from a group of servers (approx 30 instances of SQL) but that is about it.

Mmmm, interesting.

So it looks like the Primary Key constraint on the table means that the value 2 is returned last.

I've done this before using SSIS running on a Central Management Server.

Here are some links which you may find useful.

http://www.mssqltips.com/sqlservertip/2946/centralized-ssis-solution-to-monitor-failed-sql-server-agent-jobs-across-the-enterprise/

https://www.simple-talk.com/sql/sql-tools/registered-servers-and--central-management-server-stores/

http://ask.sqlservercentral.com/questions/34972/central-management-servers.html