Thanks for your advice.

The users concerned aren't in the db_owner group and they are not sysadmins so I don't think they should pick up any owner rights. Before posting the...

Thanks for your reply.

We restore a database from one server to another. On the destination database users have permissions to execute procedures and permissions on some tables.

If the owners are...

I haven't managed an AG for a while so I don't know if this will help:

If I remember correctly there is a log for the availability group which can be...

I think the information in Job Activity Monitor is based on sysjobactivity so I don't think you can update it.

It looks like it's explained here https://learn.microsoft.com/en-us/ssms/agent/monitor-job-activity

Apologies for posting a plain...

We've been having the same problem and I found this 'KB5046855 - Description of the security update for SQL Server 2016 SP3 GDR: November 12, 2024 - Microsoft Support'

Particularly the...

Apologies for taking a couple of days to reply. Those kind of checks are done by our VM admins as I'm not a VM admin.

I think by ballooning you mean...

Thank you both for your help.

The SELECT INTOs will hold locks.  Those might be causing issues.

One good way to avoid that is to an initial SELECT TOP (0) ......

• This reply was modified 9 months ago by as_1234. Reason: Trying to fix quotes

Thanks for your help.

The code you provided solved the issue and you are right I need to change it due to the SQL injection risk which I will do.

All,

Thanks for your help. That seems to have fixed the issue.

I thought I'd already tried <> rather than the unicode option with all the different variations of the username field...

Thanks for your reply and the detailed information.

Thanks for your help and apologies for taking a few days to reply.

I am looking for the permissions information regarding showplan rather than the operators. The information on the risks...

All,

Thanks for your advise. I'll change to using Operating system (cmdexec).

Thanks for the advise.

If you don't mind me asking - why do you advise that? I'm not disagreeing, I'm asking because I'm new to Powershell and interested to learn.

I think...

All,

Thanks for your help.

I think I may have just got it working with:

   if   (Test-Path -Path  $Row.Item(0))
    {
 ...

Thanks for your help. That gives me the error:

Message

Unable to start execution of step 1 (reason: line(10): Syntax error). The step failed.

This is the code:

$sqlConn = New-Object...