Description |
STEPS
1. Restore DB \\fileserver\Projects\i21Web\Databases\Demo\1520\Base Origin DB.zip
2. Update the db
update coctlmst set coctl_pt ='N'
ISSUE
8/10/2015 7:53:27 AM Error SQL72014: .Net SqlClient Data Provider: Msg 208, Level 16, State 1, Line 3 Invalid object name 'tblAPBill'.
8/10/2015 7:53:28 AM Error SQL72045: Script execution error. The executed script:
IF NOT EXISTS (SELECT *
FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[coctlmst]')
AND type IN (N'U'))
GOTO Check_Exit;
PRINT N'BEGIN CHECK coctlmst';
SET NOCOUNT ON;
DECLARE @strDBName AS NVARCHAR (MAX), @intCount AS INT;
SELECT @strDBName = db_name();
SELECT @intCount = count(\*)
FROM coctlmst;
SELECT @intCount,
@strDBName;
IF (@intCount > 1)
BEGIN
DECLARE @strMessage AS NVARCHAR (MAX);
SET @strMessage = @strDBName + ' has multiple records on coctlmst. Cannot continue upgrade.';
RAISERROR (@strMessage, 16, 1);
END
ACCEPTANCE CRITERIA
Should update properly on db without i21 schema
|