Hey SSChampion, thanks for the response, ya 2008 is the primary and the 2014 is the secondary, so leave it as restore mode... with recovery, no recovery? I tried it...

YOU SIR!!! Are you genius! i replaced -U and -P with -E like you said, THEN BAM!! WORKED... OH SO BEAUTIFUL 🙂

All good, i sadly didnt mention how it was executed, this is in a SQL agent Job that would be executed once a week, ideally.

Hey sgmunson, 
yes I definitely made sure of that, i made sure to change to username and password and to use a domain account only, we use windows authentication only...

Awesome big thanks, i am soooo close, i am not sure its on my end, or maybe something else, but its saying:

Executing Script: "\\ServerB\Results\Test.sql" Sqlcmd: Error: Microsoft ODBC Driver...

Ok quick update, i further researched the error, it did recommend i use and stick with the SA, but make sure the sql service account has access to the folder,...

YAY found the problem, after much time and pulling out my hair (Had to do a trump aka come over to cover the bald spot that hair use to reside)....

I am sorry, me = idiot, it does work, and it did spit out the sql scripts, BIG thanks so now all i have to do is like you said,...

cool, but when you say "it should have an output a list of filenames" it didnt, instead it just returned to command prompt, did it output to file? what directory?

ok i think that worked, it came back to command prompt, thats good right? sorry me = idiot 😛

cool thanks for your input, when i run in command prompt:

c:\users\mypc>FOR /f %%i IN ('\\ServerB\Results\*.Sql /B') do @ECHO %%i

i get: "%%i was unexpected at this time"

Hey sgmunson, thanks for the reply, as for the sql agent job, its running under SA, though maybe i should run it in a sql account that has access to...

thanks that worked 🙂 now to move onto the other side, and find out how to get this dang .cmd file to read all the files in a folder directory,...

ahh i gotya, but sadly that would require a link server, and for security purposes, they don't want to link servers 🙁

but that would be a good idea,...

Hey Wendy,

I had a problem similair to that a while back, one thing i did and hopefully this helps, i used a update select statement... or select update...