Thank you. I'm in the process of trying to lockdown the sa account (under considerable protest from many around me).

Thank you for all of your help.

Thank you for the suggestion.  I was wondering if it bought me anything in performance to do it this way over temporarily dropping the clustered index?  Also, how does this...

Yes, it does -- I didn't look at it, and it happened before I was called in. Start of file:

09:44:20 Begin Setup

09:44:20 Version on Media: 8.00.761

09:44:20 Mode = Normal

09:44:20...

The last one worked. Thank you all for your suggestions.

Already tried rebooting the server -- no luck. Select object_id ('sp_schedule_status_reset') as The_Nasty_One --> (null)

Query Analyzer Object Search on all object types on all db returned nothing. Alter procedure.... --> invalid object name. Create procedure --> There is already an...

select * from sysobjects so (nolock) where so.name like '%sp_schedule_status_reset%' --> (null)

select * from sysobjects so (nolock) where so.name like '%sp_schedule_status_reset%' --> (null)

Reinstalling SQL Server is a bit drastic -- this is a production server, and (for some reason) they frown on downtime.

Guess I'll try Microsoft -- just wanted to...

I apologize that this is about to hard to read, but I can't get this site to keep my spaces. Let's try this again -- I can't recreate this...

From last line of first post, error is:

There is already an object named 'sp_schedule_status_reset' in the database.

My problem is that I can't find it to get rid of it...

It's not too late -- I'll take any suggestions. (But I'm leaving now for the day, so you have until tomorrow to think of more.)

Sorry, I'm not being clear. I ran the statements in the last posting to try and find the stored procedure after I received the errors from the create statement...

SQL Server 2000, SP3.

I guess a better way to phrase my question is: How do I go about getting rid of an old copy of a stored procedure so I...