Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Cool Unanswered: find invalid views etc.


    Newbie as I am I cannot find the method to track down invalid objects in a MS SQLServer database.
    Looking through documentation and looking at internet does not provide much help.

    Please help


  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    The only method you find is the one you create using the Mark 1 mod 0 eyeball!!

    For instance ... you create and sucessfully compile a sproc. Then you alter the schema of the table and drop a column. The proc knows nothing about the altered table until you try to execute it, at which time SQL Server will throw the error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts