Post reply

Procedure not able to run

  • September 17, 2010 at 6:01 am

    #224170

    Hi All,

    i had a xyz sp in abc database.. when i ran the select * from sysobjects where name like 'xyz' and xtype='p'.. its shows the procedure name..

    i have execute the procedure.,. using exec xyz

    its shows.. invalid procedure name..

    I don't know.. why in this error came?

    Afterwards i used to three part name.. like databasename.owner.procedurename,,

    then its executed..

    can you tell me the reason..

    how can i run this procedure without giving three partname

    Thanks & Regards

    Balaji.G

  • September 17, 2010 at 6:05 am

    #1222910

    you have to specify the owner name of the SP if the owner is not dbo(which is the default owner).


    Pradeep Singh

  • September 20, 2010 at 3:54 pm

    #1224423

    In SQL 2008 these are now referred to as "Schemas". Schemas aid in categorizing database objects and are used instead of owners to address the objects.

    Owners still exist.

    The proc must be identified by schema>.<proc_name>

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply