Nice one, Steve. Thanks.

-- webrunner

Same here. I thought there were two viable answers here.

-- webrunner

Thanks, Steve, for the question. I wonder, though, if master is in Full recovery, but its log can't be backed up, does the log file just keep growing?

Thanks again.

-- webrunner

Thanks, Steve,  nice question.

-- webrunner

OK, was just wondering. Thanks!

-- webrunner

Thank you both for the advice. Regarding security, I will bring this up with our senior DBA. I didn't realize that making the SQL service account a local admin was...

Thanks to you both! Yes btw, Shared Memory is enabled, as are Named Pipes and TCP/IP.

Another reboot worked this time. But I'll trace for blocking to see what the culprit...

• This reply was modified 1 year, 5 months ago by  webrunner.
• This reply was modified 1 year, 5 months ago by  webrunner.
• This reply was modified 1 year, 5 months ago by  webrunner.
• This reply was modified 1 year, 5 months ago by  webrunner.

Thanks for this very instructive question. I didn't realize that the swap works in UPDATE statements - if that had been the question of the day, I would have gotten...

Thanks to everyone for their help. The issue was resolved by another colleague who discovered that there was a custom endpoint set up. Once the permission to that custom connection...

Great question, sorry I didn't provide this info earlier.

So far, I can log in locally and remotely using my AD login. The colleague who reported the issue can also log...

Hi Andy, Jonathan,

Thanks so much for your help. Sorry, just to clarify - I have not tested the AD login locally. That user doesn't have (i.e., is not allowed to...

One more thing I found: The SQL login works when I remote to the SQL host and log in locally. So it is something that happens for external connections.

Thanks again...

PS A little more info:

1. I was able to create a view with the same code but a slightly different name. Worked instantly.
2. Even trying to drop the original view...

• This reply was modified 1 year, 8 months ago by  webrunner.

Hi Phil,

I checked, and the view definition does not include 'WITH SCHEMABINDING'. But thanks for this info - it will come in handy.

Next I am going to review the SQL...

Hi Jeffrey,

Great, thanks for your help. I'll check the logs to see what is different between the two subsets of databases that could be causing this issue.

-- webrunner