diff --git a/qep/service/src/main/sql/mssql.ddl b/qep/service/src/main/sql/mssql.ddl
index 45e83498d..3a36ccfbc 100644
--- a/qep/service/src/main/sql/mssql.ddl
+++ b/qep/service/src/main/sql/mssql.ddl
@@ -1,8 +1,8 @@
 create database qepAuditDB;
 use qepAuditDB;
-create table "queriesSent" ("shrineNodeId" TEXT NOT NULL,"userName" TEXT NOT NULL,"networkQueryId" BIGINT NOT NULL,"queryName" TEXT NOT NULL,"queryTopicId" TEXT,"queryTopicName" TEXT,"timeQuerySent" BIGINT NOT NULL);
-create table "previousQueries" ("networkId" BIGINT NOT NULL,"userName" TEXT NOT NULL,"domain" TEXT NOT NULL,"queryName" TEXT NOT NULL,"expression" TEXT NOT NULL,"dateCreated" BIGINT NOT NULL,"deleted" BIT NOT NULL,"queryXml" TEXT NOT NULL,"changeDate" BIGINT NOT NULL);
-create table "queryFlags" ("networkId" BIGINT NOT NULL,"flagged" BIT NOT NULL,"flagMessage" TEXT NOT NULL,"changeDate" BIGINT NOT NULL);
-create table "queryResults" ("resultId" BIGINT NOT NULL,"networkQueryId" BIGINT NOT NULL,"instanceId" BIGINT NOT NULL,"adapterNode" TEXT NOT NULL,"resultType" TEXT NOT NULL,"size" BIGINT NOT NULL,"startDate" BIGINT,"endDate" BIGINT,"status" TEXT NOT NULL,"statusMessage" TEXT,"changeDate" BIGINT NOT NULL);
-create table "queryBreakdownResults" ("networkQueryId" BIGINT NOT NULL,"adapterNode" TEXT NOT NULL,"resultId" BIGINT NOT NULL,"resultType" TEXT NOT NULL,"dataKey" TEXT NOT NULL,"value" BIGINT NOT NULL,"changeDate" BIGINT NOT NULL);
-create table "queryResultProblemDigests" ("networkQueryId" BIGINT NOT NULL,"adapterNode" TEXT NOT NULL,"codec" TEXT NOT NULL,"stamp" TEXT NOT NULL,"summary" TEXT NOT NULL,"description" TEXT NOT NULL,"details" TEXT NOT NULL,"changeDate" BIGINT NOT NULL);
\ No newline at end of file
+create table "queriesSent" ("shrineNodeId" VARCHAR(MAX) NOT NULL,"userName" VARCHAR(MAX) NOT NULL,"networkQueryId" BIGINT NOT NULL,"queryName" VARCHAR(MAX) NOT NULL,"queryTopicId" VARCHAR(MAX),"queryTopicName" VARCHAR(MAX),"timeQuerySent" BIGINT NOT NULL);
+create table "previousQueries" ("networkId" BIGINT NOT NULL,"userName" VARCHAR(MAX) NOT NULL,"domain" VARCHAR(MAX) NOT NULL,"queryName" VARCHAR(MAX) NOT NULL,"expression" VARCHAR(MAX) NOT NULL,"dateCreated" BIGINT NOT NULL,"deleted" BIT NOT NULL,"queryXml" VARCHAR(MAX) NOT NULL,"changeDate" BIGINT NOT NULL);
+create table "queryFlags" ("networkId" BIGINT NOT NULL,"flagged" BIT NOT NULL,"flagMessage" VARCHAR(MAX) NOT NULL,"changeDate" BIGINT NOT NULL);
+create table "queryResults" ("resultId" BIGINT NOT NULL,"networkQueryId" BIGINT NOT NULL,"instanceId" BIGINT NOT NULL,"adapterNode" VARCHAR(MAX) NOT NULL,"resultType" VARCHAR(MAX) NOT NULL,"size" BIGINT NOT NULL,"startDate" BIGINT,"endDate" BIGINT,"status" VARCHAR(MAX) NOT NULL,"statusMessage" VARCHAR(MAX),"changeDate" BIGINT NOT NULL);
+create table "queryBreakdownResults" ("networkQueryId" BIGINT NOT NULL,"adapterNode" VARCHAR(MAX) NOT NULL,"resultId" BIGINT NOT NULL,"resultType" VARCHAR(MAX) NOT NULL,"dataKey" VARCHAR(MAX) NOT NULL,"value" BIGINT NOT NULL,"changeDate" BIGINT NOT NULL);
+create table "queryResultProblemDigests" ("networkQueryId" BIGINT NOT NULL,"adapterNode" VARCHAR(MAX) NOT NULL,"codec" VARCHAR(MAX) NOT NULL,"stamp" VARCHAR(MAX) NOT NULL,"summary" VARCHAR(MAX) NOT NULL,"description" VARCHAR(MAX) NOT NULL,"details" VARCHAR(MAX) NOT NULL,"changeDate" BIGINT NOT NULL);
\ No newline at end of file