Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: proc not deleted from information schema

    hi all,
    I have a duplicate stored procedure one has proper entries in the information_schema and the other with the same name has null entries in information schema meaning , the specific_schema and routine_schema entries are null and now it doesn't allow me to open the stored proc, neither it allows me to delete the proc.
    while deleting it says" procedure_Name not found in the (NULL) collection.
    any help will be highly appreciated.

    REGARDS,
    HARSHAL.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    sp_dboption 'db_name', 'allow', 1
    reconfigure with override
    go
    --do a delete from syscolumns and sysobjects
    sp_dboption 'db_name', 'allow', 0
    reconfigure with override
    go

Posting Permissions

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