Hmmmmm......

Okay the drugs have kicked in now!

/////////////////////////////////////////////////////////////////////////
// CreateVerityEventsTable

BOOL CComUtilDB::CLocalDataAccessor::CreateVerityEventsTable(DWORD dwArchID)
{
BOOL fSuccess = TRUE;
CString strSqlCmd, strTableName, strTableDef, strErr;
if(fSuccess)
{
strTableName.Format("PGA_PRI_%d_VerityEvents", dwArchID);
strTableDef.Format(
" CREATE TABLE %s"
" ( "
" %s int NOT NULL , "
" action int NOT NULL, "
" status int NOT NULL "
" ) ",
strTableName,
PG_RFLD_RECID
);
fSuccess = CreateSqlTable(strTableName, strTableDef);
if(!fSuccess)
{
strErr.Format(_T("can't create sql table %s"), strTableName);
AddUserError(strErr);
}
}
if(fSuccess)
{
strSqlCmd.Format(
"create trigger %sTgr on %s for update,insert as \n"
"begin \n"
" execute master.dbo.%s %d \n"
" execute master.dbo.%s %d \n"
"end \n",
strTableName,
strTableName,
m_pUDB->m_XPNs.m_strProcessChangestampsProc,
dwArchID,
m_pUDB->m_XPNs.m_strRetryProc,
dwArchID
);
fSuccess = ExecuteSQL(strSqlCmd);
}
return(fSuccess);
}

/////////////////////////////////////////////////////////////////////////
// IsSqlKeyword

BOOL CComUtilDB::CLocalDataAccessor::IsSqlKeyword(const CString& strKeyword)
{
static char* szSqlKeyWords[] =
{
"ADD",
"ALL",
"ALTER",
"AND",
"ANY",
"AS",
"ASC",
"AVG",
"BEGIN",
"BETWEEN",
"BREAK",
"BROWSE",
"BULK",
"BY",
"CASE",
"CHECK",
"CHECKPOINT",
"CLOSE",
"CLUSTERED",
"COALESCE",
"COMMIT",
"COMMITTED",
"COMPUTE",
"CONFIRM",
"CONSTRAINT",
"CONTINUE",
"CONTROLROW",
"CONVERT",
"COUNT",
"CREATE",
"CURRENT",
"CURRENT_DATE",
"CURRENT_TIME",
"CURRENT_TIMESTAMP",
"CURRENT_USER",
"CURSOR",
"DATABASE",
"DBCC",
"DEALLOCATE",
"DECLARE",
"DEFAULT",
"DELETE",
"DESC",
"DISK",
"DISTINCT",
"DOUBLE",
"DROP",
"DUMMY",
"DUMP",
"ELSE",
"END",
"ERRLVL",
"ERROREXIT",
"EXCEPT",
"EXEC",
"EXECUTE",
"EXISTS",
"EXIT",
"FETCH",
"FILLFACTOR",
"FLOPPY",
"FOR",
"FOREIGN",
"FROM",
"GOTO",
"GRANT",
"GROUP",
"HAVING",
"HOLDLOCK",
"IDENTITY",
"IDENTITY_INSERT",
"IDENTITYCOL",
"IF",
"IN",
"INDEX",
"INSENSITIVE",
"INSERT",
"INTERSECT",
"INTO",
"IS",
"ISOLATION",
"KEY",
"KILL",
"LEVEL",
"LIKE",
"LINENO",
"LOAD",
"MAX",
"MIN",
"MIRROREXIT",
"NOCHECK",
"NONCLUSTERED",
"NOT",
"NULL",
"NULLIF",
"OF",
"OFF",
"OFFSETS",
"ON",
"ONCE",
"ONLY",
"OPEN",
"OPTION",
"OR",
"ORDER",
"OVER",
"PERM",
"PERMANENT",
"PIPE",
"PLAN",
"PRECISION",
"PREPARE",
"PRIMARY",
"PRINT",
"PROC",
"PROCEDURE",
"PROCESSEXIT",
"PUBLIC",
"RAISERROR",
"READ",
"RECONFIGURE",
"REFERENCES",
"REPEATABLE",
"REPLICATION",
"RETURN",
"RESTRICT",
"REVOKE",
"ROLLBACK",
"ROWCOUNT",
"RULE",
"SAVE",
"SCROLL",
"SELECT",
"SERIALIZABLE",
"SESSION_USER",
"SET",
"SETUSER",
"SHUTDOWN",
"SOME",
"STATISTICS",
"SUM",
"SYSTEM_USER",
"TABLE",
"TAPE",
"TEMP",
"TEMPORARY",
"TEXTSIZE",
"THEN",
"TO",
"TRAN",
"TRANSACTION",
"TRIGGER",
"TRUNCATE",
"TSEQUAL",
"UNCOMMITTED",
"UNION",
"UNIQUE",
"UPDATE",
"UPDATETEXT",
"USE",
"USER",
"VALUES",
"VARYING",
"VIEW",
"WAITFOR",
"WHEN",
"WHERE",
"WHILE",
"WITH",
"WRITETEXT",
""
};
for(int i=0; TRUE; i++)
{
CString strSqlKeyword = szSqlKeyWords[i];
if(strSqlKeyword.IsEmpty() | | strSqlKeyword == _T(""))
break;
if(strSqlKeyword.CompareNoCase(strKeyword) == 0)
return(TRUE);
}
return(FALSE);
}