Home Forums SQL Server 7,2000 Strategies Limiting view to only work when called from a stored procedure RE: Limiting view to only work when called from a stored procedure

  • i actually can see how that is a good idea; some views pulling together a lot of stuff shouldn't be ad hoc queried;

    I like the idea.

    i might actually rename some tables and create views with the original name and add that feature;

    I have some MillionRowTables that developers query SELECT * FROM MillionRowTable against all the time just to see the table structure; that'd prevent any significant delays!

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!