This also works

get-childitem 'SQLSERVER:\SQLRegistration\Central Management Server Group\

It looks like you have cribbed the code from here ..https://www.mssqltips.com/sqlservertip/3489/configure-sql-server-alerts-and-notifications-for-alwayson-availability-groups/

...have you updated the job_id to your specific job ids in your code?

If not use the link as...

UPDATE - Solved! Pesky kerberos

Thanks for those of you that responded. Your ideas put me on the right track. I went back to grass routes and re-checked everything and it...

Many thanks for the response; Much appreciated. [EDIT]...Sorry - I missed the 'credential' part of your post. I will give that a go (although not sure if that works if...

ok; I know this is really old post and has surely been resolved but just in case it's not...(as there was a new post)

Run SP_helprotect @username = 'whateverUserName' on the...

See above:

Roy gave the answer. This is expected behaviour if the login is not granted view definition

Nice article although I think "Verify SQL backups" is misleading; there is nothing verifying the backups, just checking that they ran and completed. You would need to restore and integrity...

You can run it against remote servers 🙂

You could always take a look at MS Baseline Security Analyser. Not fantastic, but useful.

As long as there are not any triggers to complicate the issue, the merge statement would be another option. Not necessarily better, but at least you could update and insert...

Is it worth mentioning that sysprocesses is a deprecated table?

Is there a reason why you wouldn't just use native policy management in SQL to achieve the same?

I would think as a DBA, SP_HELPROTECT is a quicker option?

Many thanks SQL Buddy - I will test and get abck to you to let you know if it worked

I cannot get the oledb providers to work, neither the MS one or the oracle one, from within the import data function. Could you let me know the steps you...