SELECT Name from sysobjects where id in (select) bb on bb.id = sysObjects.idwhere sysobjects.name = 'stored procedure name) - by huntfox
