Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 proc not deleted from information schema

Author  Topic 

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-01-19 : 01:03:44
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.

He is a fool for five minutes who asks , but who does not ask remains a fool for life!

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-01-19 : 01:24:22
gone through this link,

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27339&SearchTerms=object,not,found,in,(null),collection
tried updating the system objects now it says specific_schema as public,but when I try to change the owner using sp_changeobjectowner, it says object does not exist in the the system schema.



He is a fool for five minutes who asks , but who does not ask remains a fool for life!
Go to Top of Page
   

- Advertisement -