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?
Andy
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?
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy