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...

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

cool got it fixed, it was "View Definition" thank you for helping and pin pointing the location.

your absolutely right, thank you, so the problem is, and yes its msdb and master, but the following tables the user doesnt have access to read the data, but doesn't...

• This reply was modified 4 years, 1 month ago by  Siten0308.

thank you all for your input and yes, I do or should have provided an example, which in the future i will next time. but found the root cause, which...