Change owner to sp_prueba

Hi,

I need to change the owner of a stored procedure called sp_prueba
created by a user time ago.

When I try to execute sp_changeobjectowner 'sp_prueba', dbo an error
appears saying than the object doesn't exists or is not valid for this
action.

I think that the problem is that the name starts with sp_ and sql
server thinks that this is a system sp.

How can I change the dbowner of this object?

Thank's in advance!!!

Un saludo,

Enrique Barceló

.

Relevant Pages

  • Re:Stored Procedure Question
    ... When you execute a SP without any owner name by default ... SQL assumes it to be dbo. ... the stored procedure fire following query. ...
    (microsoft.public.sqlserver.security)
  • xp_cmdShell
    ... role can execute this extended stored procedure. ... execute permission on my SP. ... >In SP(owner is DBO) I update table, ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL stored procedure executing twice
    ... caused the stored procedure to execute twice. ... from one parent record to another. ... Dim stDocName As String ... The table tempCount does not change until I execute the VBA code line: ...
    (microsoft.public.access.modulesdaovba)