Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002

    Unanswered: stored procedure - object name validation

    Does anyone know why MS SQL Server does not
    seem to validate object names when creating a stored proc?

    I am creating a sp with a wong table name and it still gets created!
    Its only when running the sp the error is displayed.


  2. #2
    Join Date
    Dec 2002
    Czech Republic

    Re: stored procedure - object name validation

    Add RETURN in the beginning on your SP, exec it, then alter SP to remove RETURN. Safe and fast simple parsing.
    SP is not precompiled at create time because of dynamic code support.

Posting Permissions

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