What are the odds that someone there knows about the undocumented sp_MS_marksystemobject stored procedure? If good, then that might be your problem.

I meant test if IsMSShipped is equal to 1 and see if your proc shows up. Since it's showing up when you remove the filter based on the IsMSShipped property, but...

The @fktable_name parameter doesn't work for you?

That's a bit strange. Just for fun, try changing the line...

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

to

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

I'm wondering if somehow a Null (or other non 0/1) value is slipping into that...

Take one of the stored proc that's not returning from your query, and find it in sysobjects and syscomments. Post the two rows here (you can trim the two columns with the...

Are these databases, including the new ones, all on the same server? If so, is that server 2000 or 2005? Also, are these stored procedures owned by "dbo"?

No problem at all.

You probably want to redo the ones you've already done, as the comments and objects, even though they found a match, aren't necessarily a correct match.

Where does the code run from? Since there is no "USE" in the @sql string, I'm guessing that this runs from a single location, and if that's the...

I have no idea if it will improve your performance, but there are two main options that I know of if you want the call written in T-SQL without using...

Actually, that might be a bad idea. Count(columnname) only returns the count of rows where that column is not null. Count(*) returns the actual count, including rows with nulls. I'd...

Vic, open up your Services window and check the service named Protected Storage. It should be running. If not, that's the likely culprit, so start it up and try again.

Also,...

I agree with Kenneth on this one. What you might want to do is add a a counter to your loop, and print out the counter and the code for...

Well, I count at least 6 inner joins in that cursor, and without the data, it's hard to know where they're being lost. Can you at least post the Print(@strSQLX)...

Are you mapping Dept 1 to DeptCode 200 because 2 employees that were in Dept 1 are in 200, while only 1 each are in 201 and 202? If so,...

I don't think you can do that with a standard query, as the password shouldn't be exposed to you through any interface that I'm aware of. I think ADSI only...