> I got errors about "@liError " and "ErrorHandler" not declared when
> running a stored procedure below. For Heaven's sake, I declared both
> loud and clear. The errors are where the comments are. Anyone can tell
> me what's wrong?

> -- Drop the old table
> IF OBJECT_ID('dbo.#TmpSystemParameter') IS NOT NULL
> BEGIN
>    DROP TABLE dbo.#TmpSystemParameter
>    IF OBJECT_ID('dbo.#TmpSystemParameter') IS NOT NULL
>        PRINT '<<< FAILED DROPPING TABLE dbo.#TmpSystemParameter >>>'
>    ELSE
>        PRINT '<<< DROPPED TABLE dbo.#TmpSystemParameter >>>'
> END

> GO

> DECLARE @liError int

> SET @liError = @@error
> IF @liError <> 0
> BEGIN
> GOTO ErrorHandler
> END

> -- Store data in the current "SystemParameter" table to a temp table
> SELECT * INTO #TmpSystemParameter
> FROM dbo.SystemParameter     --Error: A GOTO statement references the
> label 'ErrorHandler' but the label has not been declared.

> GO

> SET @liError = @@error
> IF @liError <> 0
> BEGIN
> GOTO ErrorHandler    --Error: Must declare the variable '@liError'.
> END

> -- Drop the old table
> IF OBJECT_ID('dbo.SystemParameter') IS NOT NULL
> BEGIN
>    DROP TABLE dbo.SystemParameter
>    IF OBJECT_ID('dbo.SystemParameter') IS NOT NULL
>        PRINT '<<< FAILED DROPPING TABLE dbo.SystemParameter >>>'
>    ELSE
>        PRINT '<<< DROPPED TABLE dbo.SystemParameter >>>'
> END

> GO

> ErrorHandler:
> Return @liError

> IF OBJECT_ID('dbo.SystemParameter') IS NOT NULL
>    PRINT '<<< CREATED TABLE dbo.SystemParameter >>>'
> ELSE
>    PRINT '<<< FAILED CREATING TABLE dbo.SystemParameter >>>'
> GO

> GRANT EXECUTE ON dbo.SystemParameter TO CRPTroubleshooters,
> GMOGMOUsers
> GO