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