How are you connecting to the database? By file? Connection string? Are you pointing to the same database in code as you are when you deleted the sproc?