• Ashish (and all) --

    Please help.

    I saw the excellent article...

    "

    How To Find SQL Server Objects

    By Ashish Kaushal, 2004/08/17

    http://www.sqlservercentral.com/articles/Advanced+Querying/howtofindsqlserverobjects/1446/[/url]

    "

    ...but I am still stuck because the Sql login that I use to check for SP existence is only a member of the following UserMappings...

    public, db_datawriter

    ...and, as such, that user does not have permissions to query sysobjects, or so it seems because such a query always returns a null result...

    ...so, is there a workaround?

    Please advise.

    Thank you.

    -- Mark Kamoski