/* Basic data insertion scripts for the minimal data elements of the control system database. */
/* Kieran Lyons */

/* note that the "control"(or control_edit) db's stuff is now 1st in file, since
its name might vary and it's whatever the active DB is when we're coming in,
and we can't 
revert to it after USEing another database(errmsgs) alas.
*/

use control

IF (LEFT(db_name(),7)<>'control')
BEGIN
	PRINT 'ERROR, active DB is ' + db_name() + ' (should be Control or equivalent)'
	DECLARE @errmsg0 varchar(128)
	SET @errmsg0='Aborting, active DB is ' + db_name()
	RAISERROR(@errmsg0, 20, 1) with log
END
print 'Using ' + db_name()

DECLARE @CTRLSYS varchar(30)
SET @CTRLSYS = ''
IF (@CTRLSYS = '')
BEGIN
	IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects 
		WHERE id = object_id(N'tempdb.dbo.CtrlSys'))
		SELECT @CTRLSYS = var FROM tempdb.dbo.CtrlSys
	ELSE
	BEGIN
		PRINT 'ERROR, CtrlSys not known'
		DECLARE @errmsg1 varchar(128)
		SET @errmsg1='Aborting, CtrlSys not known'
		RAISERROR(@errmsg1, 20, 1) with log
	END
END


 IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[NV_AddSysParamDefaults]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 BEGIN
   EXEC NV_AddSysParamDefaults
 END
 
 
 
 
 IF (EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[NV_AddControlDBDefaults]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
  AND NOT EXISTS (SELECT * FROM [dbo].host)) /* only create defaults if Hosts table is empty! */
 BEGIN
  IF (@CTRLSYS='NV900')
    EXEC NV_AddControlDBDefaults 'NVCONFIG',0
  ELSE /* do serial ports */
    EXEC NV_AddControlDBDefaults 'NVCONFIG',1
   
  PRINT  CHAR(13) + CHAR(10)+ N'Finished processing ' + db_name() + ' default data.' 
 END
 ELSE
   PRINT  CHAR(13) + CHAR(10)+ N'Either Hosts exist, or Stored procedure NV_AddControlDBDefaults does not exist, so default DB records were not created.' 


/* Set this line to the database name of the system error message database */
IF EXISTS (SELECT name FROM master..sysdatabases WHERE name = N'ErrorMsgs')
BEGIN
	USE ErrorMsgs 

	IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[ErrMsgs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
	BEGIN
		DELETE ErrMsgs

		SET IDENTITY_INSERT ErrMsgs ON
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(1, 'Failed to allocate temporary memory.', 'MemErr')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(2, 'Invalid device or device offline.', 'InvldDev')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(3, 'Router configuration error.', 'RtrCfgEr')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(4, 'Internal database state inconsistent.', 'DataErr')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(5, 'Unknown user: unable to set / release locks or protects.', 'Unk')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(6, 'Invalid router port.', 'InvldPrt')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(7, 'Destination port locked.', 'Locked')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(8, 'Destination port protected.', 'Protectd')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(9, 'Not owner of a lock / protect / release.', 'NotOwner')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(10, 'This Take will require a Tieline.', 'NeedsTL')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(11, 'Different levels.', 'DiffLvls')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(12, 'Invalid Comm port.', 'InvldCom')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(13, 'Error reading / writing Comm port.', 'CommErr')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(14, 'Unknown internal software error.', 'UnkSoft')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(15, 'Unknown internal hardware error.', 'UnkHard')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(16, 'Feature / service not supported.', 'NotSupp')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(17, 'Do Not Use', 'DoNotUse');
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(18, 'Failed to connect to NvDB.', 'DB Fail')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(19, 'Error setting up VirtualLevels structure.', 'VL Error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(20, 'Error setting up LevelSet structure.', 'LS Error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(21, 'Error setting up Device structure.', 'DevError')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(22, 'Error setting up Protocol structure.', 'ProtoErr')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(23, 'Error setting up Comm structure.', 'CommErr')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(24, 'Error setting up Router structure.', 'RtrError')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(25, 'Invalid argument(s).', 'InvldArg')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(26, 'Error accessing remote host.', 'RemHost')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(27, 'The operation was partially successful.', 'SomeFail')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(28, 'Router offline / unavailable.', 'RtrOffln')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(29, 'Do Not Use', 'DoNotUse')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(30, 'Feature not configured.', 'Not Cfg')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(31, 'Destination device is in use.', 'Dst Used')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(32, 'Source device is in use.', 'Src Used')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(33, 'Source and destination devices are in use.', 'BothUsed')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(34, 'Port is in an unknown state.', 'Unk Port')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(35, 'Data port is tristated or free.', 'Free')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(36, 'Unknown COM / DCOM error.', 'DCOM Err')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(37, 'Invalid physical level.', 'PhyL Err')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(38, 'Source port locked.', 'Locked')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(39, 'Source port protected.', 'Protectd')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(40, 'Invalid source.', 'Inv Src ')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(41, 'Invalid destination.', 'Inv dst')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(42, 'Invalid level.', 'Inv lvl ')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(43, 'Invalid router.', 'Inv Rtr ')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(44, 'File Input / Output error.', 'File I/O')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(45, 'Failed system resource allocation.', 'Sys Rsc ')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(46, 'Failed system synchronization object.', 'Sys Sync')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(47, 'There is no free source configured for the specified level.', 'No Free ')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(48, 'Do Not Use', 'DoNotUse')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(49, 'The virtual crosspoint path is invalic.', 'Path Inv')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(50, 'Virtual crosspoints are uninitialized.', 'Not Init')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(51, 'There is no device configured for that port.', 'No Dev')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(52, 'Retry the operation.', 'Retry')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(53, 'Error creating ADO COM interface', 'ADO err')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(54, 'Error connecting to ErrorMsgs database.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(55, 'Error in the SysError messages table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(56, 'Error in the UserError messages table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(57, 'Error connecting to the control database.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(58, 'Error reading NvUser table', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(59, 'Error reading Virtual Level table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(60, 'Error reading Virtual Level composite table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(61, 'Error reading Level Set table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(62, 'Error reading Level Set Details table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(63, 'Error reading Device table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(64, 'Error reading Category table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(65, 'Error running Device List / Category query.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(66, 'Error reading Physical Level table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(67, 'Error reading Router table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(68, 'Error reading Host table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(69, 'Error reading Control Point table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(70, 'Error running Control Point sort query.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(71, 'Error reading Router Control table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(72, 'Error reading App table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(73, 'Error reading Physconn table.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(74, 'Failed router control dll.', 'Dll err')

		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(77, 'Local log failure.', 'Log err')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(78, 'Router control error.', 'Rtr err')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(79, 'Composite router error.', 'Comp err')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(80, 'The returned recordset is empty.', 'Empty')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(81, 'You lack authority to perform the requested action.', 'No Auth')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(82, 'The component is not initialized.', 'Uninit')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(83, 'Unknown failure.', 'Unk err')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(84, 'There is an error in the configuration.', 'Bad cnfg')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(85, 'The component is not active.', 'Not Actv')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(86, 'The database schema is incorrect.', 'DB error')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(87, 'Shutting down.', 'Shutdown')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(88, 'No Tieline available.', 'NoTLAvl')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(89, 'The Tieline is Offline.', 'TL Offln')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(90, 'Using a Tieline.', 'Using TL')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(91, 'Tieline carrying unknown Source', 'TLUnkSrc')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(92, 'Tieline Fan-in Breakaway.', 'TLFIBrky')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(93, 'Wrong Interface or Version thereof.', 'WrngIntf')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(94, 'Invalid ID.', 'Invld ID')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(95, 'Source Chop.', 'Src Chop')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(96, 'Source Breakaway.', 'Src Brky')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(97, 'Used as master point to point.', 'P2PMastr')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(98, 'Used as master without responses.', 'MstNoRsp')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(99, 'Used as broadcast master.', 'BcstMstr')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(100, 'Do Not Use', 'DoNotUse')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(101, 'Used as slave point to point.', 'P2PSlave')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(102, 'Used as slave without responses.', 'SlvNoRsp')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(103, 'Used as broadcast slave.', 'BcstSlv')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(104, 'Do Not Use', 'DoNotUse')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(105, 'No license available', 'NoLicens')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(106, 'Crosspoint Excluded', 'Excluded')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(107, 'Too many virtual reentries.', 'TooManyV')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(108, 'Cannot go active.', 'CantActv')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(109, 'Output Follow.', 'OutFolow')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(110, 'Embedder is bypassed.', 'EmbBypas')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(111, 'Source from disembedder.', 'SrcDisem')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(112, 'Source from re-embedder.', 'SrcRe-em')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(113, 'Destination is a disembedder.', 'DstDisem')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(114, 'Destination is a re-embedder.', 'DstRe-em')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(115, 'No disembedder available.', 'NoDisAvl')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(116, 'No re-embedder available.', 'NoRe-emb')
		INSERT INTO ErrMsgs(ErrMsgs_ID, ErrMsgs_English, ErrMsgs_ShortEnglish) VALUES(117, 'Incompatible Port types.', 'NoCompat')

		SET IDENTITY_INSERT ErrMsgs OFF
	END

END
ELSE
	PRINT 'ErrorMsg database does not exist'
	
PRINT  CHAR(13) + CHAR(10)+ N'Finished processing ErrorMsgs data.'


PRINT  CHAR(13) + CHAR(10)+ N'Finished processing Baseline Data script.'
GO
