• If the error is happening because a proc is called inside another proc (or something like that) and you have permissions to see the proc, running this little code snippet might help:

    EXECUTE sp_MSforeachdb @Command1 = 'SELECT DB_NAME() AS DatabaseName, name AS ProcName FROM sys.objects WHERE name = ''MyProc''';

    This assumes the proc is on the same Instance, not being referenced by a linked server.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.