Home Forums SQL Server 7,2000 T-SQL Exists some table that the alters of SP are registered? RE: Exists some table that the alters of SP are registered?

  • Yes, however ALTER will create a second entry in sysobjects with an increased value of base_schema_ver.

    DROP will remove all these entries and another CREATE will set it back to 0.

    using the combination of name,crdate and base_schema_ver could be enough

    Far away is close at hand in the images of elsewhere.
    Anon.