September 17, 2001 at 2:03 am
I was trying to use above mentioned stored procedure but hit the following error :
Msg 229, Level 14, State 2
SELECT permission denied on object #SQLOLEDbUserProfile00000000F6, database tempdb, owner dbo
Any idea how to solve it ?
September 17, 2001 at 5:48 pm
My guess (and only a guess) is that you're trying to access a protected temp table. Maybe modify the proc to skip tables that start with a #? And/or skip tempdb altogether?
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
September 18, 2001 at 7:30 pm
The temp object was created once I connected to SQL server. If I choose to skip the temp table, sp_MSforeachdb will complain the object is not found.
Any suggestion ?
September 19, 2001 at 4:35 am
I dont have 6.5 installed ANYWHERE. Let me see what I can come up with. Steve?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply