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
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??
Microsoft SQL ServerMicrosoft SQL Server 2005
Last Comment
Charles Baldo
ASKER
Thank You Vitor, but I tried that first and no success, this should be simple I agree
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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