Grey aka Melanie
Grey aka Melanie
Thanks! Is there a documentation on Query() and other methods available on the $server/$db objects or any other examples? I just get the error "Execute with results failed for Database...
Yeah I thought about using ExecuteNonQuery as well (saw it in the Connect-DbaInstance documentation) but I get an error there as well, "ExecuteNonQuery failed for Database 'msdb'". Just did some...
Yeah my problem was (and still is) that I cannot execute the script created by exporting jobs with dbatools because the quoted GOs aren't read as quoted GOs. When I...
I changed the names and the login because of confidentiality and stuff but here's the script. I can assure you that every db that would be in the file exists,...
Not sure about the missing declare, for me it worked in SSMS but I will try to fix it and see if it would work then. Though I believe the...
I have a declare at the top, I guess I didn't select all code when I pasted the script. It should be this: ``` USE [msdb] BEGIN TRANSACTION DECLARE @ReturnCode...