I've been a consultant for over 25 years, and I can safely say that this is a negotiable item.

As a consultant I would always like to get paid for doing...

TC?

The standard technique for this is to add a dummy clause to the WHERE:

strWhere = " WHERE (1=1) "

For i = 1 to 4

strWhere = strWhere...

OK, thanks to Matt's link & insights, I was able to get this to work without having to resort to MS's three line preamble:

Select @xml.value('(/*:Error/*:_Description/text())[1]', 'nvarchar(255)' )

The underscore is just...

OK, I've got it now. And thanks for the link, it's not what I was hoping for, but it is exactly what I needed.

Matt Miller (4/11/2008)

---

perhaps, but they are going to be REQUIRED as of SS2011. Yes - those useless placebos will be EVERYWHERE.... Apparently someone's not confident that the parser...

Yeah, but that shouldn't matter, Namespace declarations are just labels, they...

Matt: unfortunately, I do not actually have any control over this XML, as it is a Microsoft error message returned by Service Broker. I just quickly mocked the...

Wow.

I really wish that the {code} IFcode tags would treat their contents as literals and not strip out the html & xml tags.

Michael Earl (4/7/2008)

---

This is a batch separator. In some places, it will impact what your scripts will do.

The semi-colon you have included is also a batch separator but is...

Jonathan Beck (4/10/2008)

---

I do thank you very much for your assistance with this one but alas this does not work for me.

It does not allow me the flexibility of the...

I hope that you're not trying to take credit for Joel's fine work...

That won't fix it if it's being caused by replication.

Sridhar (4/9/2008)

---

Hi,

we are using sql server 2005. We have some queries that will take long to complete. When the user is running these queries, we can see...

A) do you have replicaiton on this database?

B) any open transactions on this database?