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 18 hours, 47 minutes 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...

Hello,

Thanks for your help.

Apologies I didn't mean to be vague. I've now added the commandtext to my original post. At the moment the table has one row and the filename...

Hello,

Thanks for your help. I hadn't seen that and it it looks interesting. I will take a look.

I didn't specify when I created my post but I was more thinking...

Thanks for your reply.

All: Thank you for your help. I put in some code to update the stats and it seems to be solve the issue consistently and now I...

I've discovered that the table is updated overnight and the issue re-occurs overnight.

If I run the code in the morning then it takes too long to complete. If I then...

• This reply was modified 7 months, 4 weeks ago by  as_1234.

All,

Thanks for your help.

I updated the statistics today and it seems to have fixed the issue. I will retry the code over the next few days to see if it...

All,

Thank you for your replies and suggestions. Sorry I haven't been back to this topic, I've had some other unplanned things to sort out. When I get back to it,...

• This reply was modified 8 months, 2 weeks ago by  as_1234.