ms sql server - error
I am trying to run a bloack of code...but getting the following error:
Msg 229, Level 14, State 5, Line 32
The EXECUTE permission was denied on the object 'DateOnly', database 'WSD', schema 'dbo'.
Msg 208, Level 16, State 0, Line 55
Invalid object name '#ShoeTotalsUser'.
does this mean that I dont have access to the DB to run the EXECUTE
2) #ShoeTotalsUser is a temp table or a view and when the system runs this inside a sproc runs fine, im trying to run locally but now this issue...how do I view this?
Msg 229, Level 14, State 5, Line 32
The EXECUTE permission was denied on the object 'DateOnly', database 'WSD', schema 'dbo'.
Msg 208, Level 16, State 0, Line 55
Invalid object name '#ShoeTotalsUser'.
does this mean that I dont have access to the DB to run the EXECUTE
2) #ShoeTotalsUser is a temp table or a view and when the system runs this inside a sproc runs fine, im trying to run locally but now this issue...how do I view this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I looked at the sproc and its not creating a #temp_table in it...yet it works fine when called by the .net web app...i dont know or see where its being created...odd..
ASKER
this doesnt work for me:
select * from #table_view