Minor correction, you might want to do a left outer join on sys.columns, instead of a inner join, since not all check constraints will be bound to a column. Constraints...

"(though the documentation says it requires sysadmin privileges but it works just by giving execute permissions on the sp_OA* procedures)"

The documentation seems to be correct in my experience. I couldn't...

Close. I found there were two problems. I had recently done a restore, so the database login and user were disconnected (and of course SQLServer doesn't tell you this).

I fixed...

Thanks!

Yeah, I realize that sysobjects doesn't contain everything. I'll probably end up going the similar route of writing a bunch of custom queries, but for now I'm trying to keep...

So so. While sysobjects does contain the name of most objects (the exception being indexes), it doesn't directly contain the parent object. I need to do another join using parent_object_id...

Ah, ok, thanks for the clarification.

Is it possible to construct an URN that can query by name, regardless of type?

I tried these, for finding the MyProc, but none of them worked:

//[@Name='MyProc' and @Schema='dbo']

//.[@Name='MyProc' and @Schema='dbo']

//*[@Name='MyProc'...

Thanks, that's an enormous help!

Is there any documentation on GetByURN?

I did a Google search, but apparently the only page on the net that uses that term is this thread 🙂

http://www.google.com/search?q=SMO+GetByURN&btnG=Search

Thanks, that's exactly what I'm looking for.