Yes, the linked server worked before the upgrade and the event logs don't provide any other insights. I've also tried other servers with the same configuration (Windows Server 2019, SQL...

You, sir, are my hero. So you need to declare xmlnamespaces whenever the namespace is included in the XML tag?

Thanks again!

We're not too worried about restoring since these are only going to be small sets of tables (1-5 tops). I'm hesitant to create individual databases containing only a couple...

That's exactly the problem I'm having. We don't know what all of these applications are going to be and they might not always be related to our POS system....

Yes, they will always be in the second place in the list. We shouldn't have to join the results to another table.

Yep, I removed the TOP 30 limitation and I had to make a few minor changes to the script that generates the UPDATE statements, but other than that it worked...

Lowell, you sir, are a genius. Your solution worked perfectly. I can't thank you enough. Sorry I didn't include an example table and data, I'll be sure...

I don't simply store the tag in the text column, I store entire web pages. I need to sift through 5,000 lines of text to replace %20 with an...

Yes, the html is stored in a SQL 2005 database in a text column. My problem is, I can't use the REPLACE function the way you describe because the...

Gotcha, thanks. I think it was the wording that threw me off. ('Use row locks...' and 'Use page locks...') It made me think it would always use...

But wouldn't you want one or the other, instead of both?

Nope, no clean up tasks and I set it up exactly like the other servers. I've been log shipping to our hot site for the past three years and...

I took a look at the table and on both the Primary Server and the Monitor Server, it shows the databases as never having a log backup. However, when...

Thanks so much for the reply. Forms authentication is really what I was after and it looks like the MSDN post will do the trick. I'm going to...

Fantastic! Thanks for your help. Everything is working perfectly now. If anyone needs it, this is the xml format to pass to the google maps api.