Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

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?
0
GlobaLevel
Asked:
GlobaLevel
  • 2
1 Solution
 
GlobaLevelAuthor Commented:
also how do I see a view? for table structure and data

this doesnt work for me:
select * from #table_view
0
 
Ephraim WangoyaCommented:
The stored procedure is most likely creating the temp table then deleting it afterwards
0
 
GlobaLevelAuthor Commented:
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..
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now