What's wrong with this Stored Procedure

[tharrel1]

I am getting the errors:

Msg 208, Sev 16: Invalid object name 'Archive_VTWINTABLE'. [SQLSTATE 42S02]
Msg 208, Sev 16: Invalid object name 'VTWINTABLE'. [SQLSTATE 42S02]

I checked my tables names and they match the names in the stored procedure.



CREATE PROCEDURE [p_Archive_VTWINTABLE]
AS
Declare @dateCurrentDate datetime
Declare @dblCutoffDays float
Declare @strCutOffDate varchar(11)
Declare @dateCutOffDate datetime

Select @dateCurrentDate = GetDate()
Select @dblCutOffDays = 8 * -1 -- 8 equates to the number of days to keep records in short
Select @strCutOffDate = DateAdd(d, @dblCutOffDays, @dateCurrentDate)
Select @dateCutOffDate = Convert(DateTime, @strCutOffDate)

INSERT INTO Archive_VTWINTABLE SELECT * FROM VTWINTABLE where
RecDate < @dateCutOffDate

Delete VTWINTABLE from VTWINTABLE where
RecDate < @dateCutOffDate
GO

[Memnoch1207]

it doesn't recognize the names...try putting either [] around them or if the names are actually capitalized...try putting quotes around them.

[tharrel1]

Tried quotes and brackets and still same error.

[Granty]

As a check try using the full path of the tables:

[ServerName].[DatabaseName].owner.[TableName]

Hard to help on this one as we cant see your server

[techgnome]

Two things come to mind....
1) Try specifying the actual field names in the insert...
2) The delete is wrong...
Delete from VTWINTABLE where
RecDate < @dateCutOffDate

It's just Delete From (tbl name)..... not Delete X From (tbl name)....