Viewing 15 posts - 1 through 15 (of 153 total)
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,...
March 25, 2022 at 7:45 pm
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...
March 25, 2022 at 2:55 am
YOU SIR! are a genius thank you 🙂
February 1, 2022 at 8:03 pm
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...
February 1, 2022 at 7:19 pm
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...
September 13, 2021 at 7:28 pm
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...
May 15, 2021 at 12:01 am
nevermind, hope this helps, i found the solution, though just need to change the tables to match whatever tables you are doing:
this example above in the link groups...
March 25, 2021 at 2:27 am
got it working now,:
this helped below.
February 23, 2021 at 8:48 pm
Thank you sir, worked perfectly 🙂
February 16, 2021 at 11:09 pm
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...
January 12, 2021 at 2:05 pm
ahh cool let me try that out, big thank you sir 😉
October 13, 2020 at 6:02 pm
Hey Phil 🙂
Yes they are in the same Domain
October 13, 2020 at 3:55 pm
cool got it fixed, it was "View Definition" thank you for helping and pin pointing the location.
October 7, 2020 at 1:45 pm
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...
October 7, 2020 at 1:35 pm
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...
October 2, 2020 at 8:30 pm