Charles Baldo
asked on
Stored Procedure needs owner to execute
Working is SQL server 2005 using SSMS 16
I have a stored procedure in a database exec get_info 'ID175143'
Msg 2812, Level 16, State 62, Line 22
Could not find stored procedure 'get_info'.
So I do exec [WorkDatabase].[owner].get _info 'ID175143'
This would be okay but many of the sp's call other sp's so I get these kind of errors
Msg 2812, Level 16, State 62, Procedure get_info, Line 9 [Batch Start Line 19]
Could not find stored procedure 'get_info_base'.
How can I get around this??
I have a stored procedure in a database exec get_info 'ID175143'
Msg 2812, Level 16, State 62, Line 22
Could not find stored procedure 'get_info'.
So I do exec [WorkDatabase].[owner].get
This would be okay but many of the sp's call other sp's so I get these kind of errors
Msg 2812, Level 16, State 62, Procedure get_info, Line 9 [Batch Start Line 19]
Could not find stored procedure 'get_info_base'.
How can I get around this??
ASKER
Thank You Vitor, but I tried that first and no success, this should be simple I agree
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The owner was replaced by/separated from schema in SQL Server 2005.
As a result of this change, you should use at last always the schema.objectname syntax cause it's faster (name resolution and binding) and the dynamic object binding is normally not used.
As a result of this change, you should use at last always the schema.objectname syntax cause it's faster (name resolution and binding) and the dynamic object binding is normally not used.
ASKER
Thanks Vitor,
Unfortunate that is the case. I get it now
Unfortunate that is the case. I get it now
Open in new window