ms sql server - error

Posted on 2011-10-13
Last Modified: 2012-05-12
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 do I view this?
Question by:GlobaLevel
    LVL 10

    Author Comment

    also how do I see a view? for table structure and data

    this doesnt work for me:
    select * from #table_view
    LVL 32

    Accepted Solution

    The stored procedure is most likely creating the temp table then deleting it afterwards
    LVL 10

    Author Comment

    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..

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now