October 10, 2008 at 8:24 am
Anyone ran into these error messages when trying to run a stored procedure? I don't know what those objects are.
Msg 15151, Level 16, State 1, Line 3
Cannot find the object 'queue_messages_1189969153', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 3
Cannot find the object 'queue_messages_1221969267', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 3
Cannot find the object 'queue_messages_1253969381', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 3
Cannot find the object 'filestream_tombstone_2098496392', because it does not exist or you do not have permission.
The Redneck DBA
October 10, 2008 at 8:53 am
What's the stored procedure doing? It's what it says, the proc is trying to reference those objects and they either don't exist or the user can't see them.
October 10, 2008 at 8:53 am
What's the stored procedure doing? It's what it says, the proc is trying to reference those objects and they either don't exist or the user can't see them.
October 10, 2008 at 9:11 am
It's just granting some security. It doesn't call those objects, unless SQL calls them behind the scenes. And the user I'm running it as is both an admin to the server itself, and a sysadmin in SQL.
The Redneck DBA
October 10, 2008 at 9:14 am
Can you share the Logic/Code of SP to better dig in ....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply