Thanks a bunch! This is helpful, and I will work through your recommendations to see what I find.

UPDATE: Just saw rVadim's reply. That solution has a better execution plan from my tests.

It that field does actually contain the same value, here is another idea:

with...

• This reply was modified 5 years, 8 months ago by  DataAnalyst011.

Is the field keyinstn really the same value for both rows? I wasn't sure if that was actually intended to be a primary key (at least in concept), which would...

Ha, yes - it didn't look hopeful there for a while 🙂 It turns out the max memory setting was accidentally set to almost zero. The trick is to startup...

...and we're back online.

The fix was to stop Agent and set the service to manual. Then we entered -f as a startup parameter for engine in configuration manager. After bouncing...

I tried this but received the same error (in DAC)

https://blog.sqlauthority.com/2018/08/16/sql-server-error-17300-the-error-is-printed-in-terse-mode-because-there-was-error-during-formatting/

You all are a life-saver. Thank you so much for all the advice. I've switch most components to dedicated system accounts and generally tightening security.

I'm going to...

Thanks a bunch! Will him being the owner of the database cause issues? I mean, it makes sense that it would but I'm just prioritizing addressing the issues at the...

This was very helpful. I worked through the article and then worked through the an example here: https://www.sqlskills.com/blogs/jonathan/certificate-signing-stored-procedures-in-multiple-databases/ . I have the basic setup working in my test environment.

Thanks for the replies! I am working through them.

Thanks to everyone for these very helpful suggestions and tips. Querying XML has always been a bit baffling to me. I really appreciate it!

1) Thanks a TON! This is so helpful.

2) I had a couple of lines that were failing on syntax. After looking closer I found stuff like this:

I think you are probably right. I've been getting around it with scripts that turn page locking on before the job and then off again. Its an app we purchased,...

Hi Grant - thanks a bunch for the links. I've already started working through them. It does look like this instance is behind on service packs. I will make that...