All, sorry for not replying to the thread. The secondary server has been offline since Saturday. I have a maintenance window tomorrow so the plan is to reseed via...

• This reply was modified 5 months, 2 weeks ago by  Jeffrey Williams.

If there are any additional transaction log backups taken before you complete restoring the logs on the secondary - it will fail with that error.  You have to apply all...

Thank you for the update - glad that worked out for you.

Take a look at the tools from here: https://dbatools.io/

Not sure why your COUNT didn't work - this works just fine:

DECLARE @person TABLE (PersonID int PRIMARY KEY CLUSTERED, sName varchar(30));
 INSERT INTO @person (PersonID, sName)
 VALUES...

The problem in Steve's solution is that is doesn't account for possible CR/LF data in the last field.  In your data - there is a CR\LF after the comma in...

• This reply was modified 7 months ago by  Jeffrey Williams.

Why does it need to run asynchronously?

If that is the goal - setup an agent job to run the package using the Integration Services subsystem with the appropriate proxy account...

This works - for the given example:

DECLARE @string NVARCHAR(MAX) = N'"T1","T2","T3","T4","T5"
"000055555XYZ",00001,"","","BLUEF, NA"';

  PRINT @string
    SET @string = replace(replace(replace(replace(replace(@string, char(13)+char(10), ','), '","', '|'), '",',...

Thanks Jeffrey..

Yes, I'll review the one with ID included. The script I posted above does archive the desired results. I was thinking that I could just issue a Truncate...

Please review the script I posted - that you ran and successfully returned a result.  You will notice that query returns the ID along with the SQL to execute -...

No - your original request is attempting to connect to a single server and pull data *across a...

So now even more confusion - because you cannot seem to provide the information requested.  Why are you able to connect to 'localhost' but not to the actual server in...

I agree with everything already said - this is a bad design.  With that said - let's start with the first part and see if you can get that working:

Your query needs to have the server name quoted - as in: SELECT ... FROM [server-with-dashes].database.schema.table

And - you most likely need to quote the server name in $ServerInstance - as...

The problem isn't in the PS portion - it is in the SQL query.  You need to enclose the 'linked' server reference in the query - although I have no...