I refined this as follows to make the result more meaningful...

create procedure myproc @mysearch varchar(100)

AS

SELECT  sysobjects.name,

    substring(syscomments.text,charindex(@mysearch,syscomments.text) - 10, 255)

   FROM

    sysobjects,syscomments

   WHERE

    sysobjects.id = syscomments.id

  ...

Two possibilities:

Domain trust.  If the server is in domain A, the login is DomainB\username, and there is no trust between domain A and B, this will occur.

NT 4 Domains.  NT...

We do this type of thing quite often.  However, if the record already exists, it is up to the caller to provide the ID.  This avoids the select.  We also...