ugh... so one thing, i realized... is always check the naming... of the file... really sorry, everything you mentioned is great troubleshooting... when i found the file.. it was 1...

I am currently running the TSQL statement on the server directly.

i gave the built in sql server user account full access to that path, sadly still same error message.

thanks Jeff, its the Nt service default login, should i grant that login to the path?

Hey Michael good point, which now putting it all together, i think I might see a problem here... and the keyword is trigger, which from table 1 on database A,...

Hey Brian, big thanks for responding, and yes, also i forgot to mention, we are doing an Order by, and yes, we did just remove that Nolock, good catch on...

YOU SIR! are a genius thank you 🙂

sorry, i found the issue, However now the problem comes up where it tries to insert but due to it as xml, within the XML there is some databases that...

Hey Ant-Green,

thank you for your reply,

so very very weird... on Server 2 and 3, when i do the NSlookup, the ip addresses in order are never consistant.. example

first time i...

ohh sorry, yes if one of the taboo characters is in the string then reject the entire entry. should this or is it best to be done as a trigger...

nevermind, hope this helps, i found the solution, though just need to change the tables to match whatever tables you are doing:

https://stackoverflow.com/questions/7068235/group-by-every-n-records-in-t-sql

this example above in the link groups it by...

got it working now,:

this helped below.

https://blog.revathskumar.com/2018/02/nodejs-list-s3-directories-with-aws-sdk.html

Thank you sir, worked perfectly 🙂

ok thank you all for your input...

so this is what i wanted to accomplish, i want to run a inventory of sql databases, and I have a registered server that...

ahh cool let me try that out, big thank you sir 😉

Hey Phil 🙂

Yes they are in the same Domain