Re: Could not find stored procedure

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 14:29:30 +0530

Hi ,

To add on to Dejan Sarka post , Simply execute the below query in Query
analyzer

select user_name(uid) as Creator,name from sysobjects where name =
'procedure_name'

Replace the procedure_name with actual name.

Incase the the creator name is not DBO then use sp_changeobjectowner (refer
books online) to change the object owner.

Thanks
Hari
MCDBA

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
message news:ugW0lfCAEHA.2660@TK2MSFTNGP10.phx.gbl...
> Hi!
>
> The user that creates the procedure is owner of te procedure, if it was
not
> created with a specific owner (i.e. CREATE PROCEDURE owner.name). The sa
> loin is mapped to a specific db user dbo, so SQL Server searches dbo.name
> procedure. Eithercreate all n+bjects wit dbo as owner, or use two-part
name
> when using it.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
> "Sandip" <bsandipk@hotmail.com> wrote in message
> news:072701c40022$9dd31140$3501280a@phx.gbl...
> > User creates a sp and the same is visible in the
> > enterprise manager. The user has rights to execute also.
> >
> > However the isql gives the above mentioned error even for
> > sa!!!
> >
> > No clue please help.
>
>

Relevant Pages

  • Re: SQL Query Performance
    ... Execute the query and see which is faster. ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > I want to select Fleet_Id and Fleet_Name from fleet table> Where the current user has privilege. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2000 manual start job sort order
    ... As you might know, without ORDER BY, SQL Server is free to optimize and execute a query in any way ... then the optimizer has to ...
    (microsoft.public.sqlserver.server)
  • Re: Closing a connection BEFORe command execution has completed
    ... closing the connection with Connection.Close does not close the connection--it simply releases it back to the pool so the engine will continue to fill the cache--but it's not that large so the operation might simply hang resources on the server until the connection is reused. ... The problem is, since all of the Execute methods are synchronous, there is no way to interrupt the query or action command process. ... Because of the way TDS and SQL Server responds to cancel requests your operation might not be immediately "stoppable"--SQL Server might have some cleanup to do before releasing control and resources. ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL Server 2005 with iSeries DB2 Linked Server problem
    ... I have the linked serverset up and and I can execute the ... following query from the SQL Server Management Studio and it works ... I can even create a view of the query in my Master ... database and it works from the SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Comparision on Char Column With Alphanumeric Values
    ... >> Dejan Sarka, SQL Server MVP ... >>> The query returns 0 records, whereas ideally it should return records ...
    (microsoft.public.sqlserver.server)