error in sql

See more:

SQL

Hi,

I had written one storedprocedure for deleting the current leaves.
But when I am debugging I am getting the error as invalid object name.

I am posting the code.

USE [HDCHRMSDB]
GO
/****** Object: StoredProcedure [dbo].[apDeleteCurrentYearLeaveSummery] Script Date: 01/04/2011 12:23:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[apDeleteCurrentYearLeaveSummery]
As
BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.

SET NOCOUNT ON;
DELETE FROM CurrentYearLeaveSummery Where Year=2011


END

When I am using as Delete from dbo.currentyearleavesummary where year=2011 also it is geeting same error.

In my project currentyearleavesummary is the table exists, even though the error is coming.

Please suggest me a solution.
Please suggest any answer to avoid that error. It is urgent for me.