My answer was an absolute guess.  I had no clue.  I just kept thinking about how many pages it would take and how to link them all together.

NOOOOOO!  The kingdom I inherited over 10 years ago had seen several different programmers and between duplication and poor design, they created a monster that I'm still dealing with.  CHAR...

I didn't know it, so I googled it and found it here https://www.sqlservertutorial.net/sql-server-basics/sql-server-offset-fetch/

but the answer didn't just jump out.  I used process of elimination.  If this is cheating,...

When you say "The SQL code to add to the job is shown here:" do you mean add it to the end of the job or where?

Excellent and well-written.  Unfortunately I'm still on SS 2008!  However, that changes in January. So, hopefully I get a chance to practice this technology.  Thanx!

Execute xp_cmdshell 'BCP Mailing.dbo.tTotalJimsListNEW IN "\\MyServer\Shareddata\MyFolder\Mailing Lists\ListtoImport\RemovalsNoCusts.txt" -c -S SQL1 -U me -P mypassword'

I run scripts like this from an SSMS query window,

the example given would be run from ad hoc queries in SSMS.  Similar imports, which have a static naming convention run from stored procedures.  Yes, a trusted connection could be...

Wow!  I'm going to play with this a while.  That's the best way for me to learn.
Thanx!

Amen on "start down the PowerShell learning path that I should have been going down for the past several years."  I'm in that same boat.  This looks like an excellent...

What version of SQL Server are you using?
What application are we seeing in the Screenshot?  It doesn't look like SSMS (at least SSMS 2008). 
I'm using Log Shipping but...

I haven't tried this, but thought you might want to.

Leave the old database in place. I know you have moved the tables to a new DB.

Create Views in the...

Ours are attached. They've been modified recently to accommodate a log shipping setup. The logs cursor through a table which consists of database name and a bit field...

Yep, this answer is dead on. It removed agent jobs from the primary and secondary.

After that I just deleted the secondary database which was in Read Only mode.

Thanx!

Joie,

Yes, the copy job has worked all along(see caveat below) and I checked the backup folder against the restore folder on the Secondary. They have the exact same files....

Certainly a viable option, but the above code is part of a stored procedure, the first part of which populates a table which is then exported. The proc is...