The odds are pretty low. What can you tell me about it?

David:

OK, sorry to be so thick. When I test for IsMSShipped = 1, the "missing" stored procedure DOES show up, along with a whole slew of system stored procedures...

David:

Changing

(OBJECTPROPERTY(O.ID, 'IsMsShipped') = 0)

to

(OBJECTPROPERTY(O.ID, 'IsMsShipped') 1)

produces the same results as before. I'm not sure what you mean by "Alternatively, SELECT the ones equal to 1", as I'm already doing...

SP20 is just the name of a test stored procedure I threw together in about 45 seconds. Any objects not intended strictly for testing have appropriately self-documenting names.

The two rows are below. I've found a workaround mentioned several places on the web, that seems to give me correct results, but I feel uneasy about it as...

At this point, I'll be thrilled if I can get this working on a single server. All of our servers are SQL 2000. As far as I know...

Oops - I spoke too soon - making both tables qualified did cause a stored procedure to show up, but on closer examination it is NOT the user defined one...

You've once again proved the value of a second pair of eyes. As soon I added the qualification to syscomments, the code picked up the "missing" stored procedure. ...

Thanks, Jeff!

I fixed the truncation in QA by changing the appropriate setting there. But I'm using the same code in a stored procedure called by a DTS package. The...

Hmm, that's odd. I was getting a similar error when I first started developing this code, but am not now. But it's still truncating the [text] field and...

That seems to be true for some of the top-level topics (e.g., Analysis Services and Data Mining), but NOT for the first (and presumably most fundamental) one, SQL Server Tools.  If...

The article is very poorly written, and apparently not even proofread.