Most of the queries that are defined within the 6.00.03.SQLDataProvider file are missing the objectQualifier and databaseOwner declaration from the body of the SQL Query resulting in errors from DNN installations that use the objectQualifier. Please see example below, the bolded areas are the areas that are missing the objectQualifier and the databaseOwner declaration;
CREATE PROCEDURE {databaseOwner}[{objectQualifier}UserDefinedTable_FillDefaultData]
@ModuleID INT,
@FieldId INT, /* can be null for any field */
@DefaultValue NVarChar(max) /*can be Null to copy default expression (no evaluation!) */
AS
IF @DefaultValue is Null
INSERT INTO dbo.UserDefinedData (UserDefinedFieldId, UserDefinedRowId, FieldValue)
SELECT F.UserDefinedFieldId, R.UserDefinedRowId, [Default]
FROM (dbo.UserDefinedFields F
INNER JOIN dbo.UserDefinedRows R ON F.ModuleId = R.ModuleId)
LEFT JOIN dbo.UserDefinedData D ON F.UserDefinedFieldId = D.UserDefinedFieldId AND R.UserDefinedRowId = D.UserDefinedRowId
WHERE (D.UserDefinedRowID Is Null) AND ([Default] IS Not Null) AND (@ModuleID = F.ModuleId) AND (@FieldId IS Null OR F.UserDefinedFieldId = @FieldId)
ELSE
INSERT INTO dbo.UserDefinedData (UserDefinedFieldId, UserDefinedRowId, FieldValue)
SELECT @FieldId, R.UserDefinedRowId, @DefaultValue
FROM (dbo.UserDefinedFields F
INNER JOIN dbo.UserDefinedRows R ON F.ModuleId = R.ModuleId)
LEFT JOIN dbo.UserDefinedData D ON F.UserDefinedFieldId = D.UserDefinedFieldId AND R.UserDefinedRowId = D.UserDefinedRowId
WHERE (D.UserDefinedRowID Is Null) AND (@ModuleID = F.ModuleId) AND (@FieldId IS Null OR F.UserDefinedFieldId = @FieldId)
GO
ALTER PROCEDURE {databaseOwner}[{objectQualifier}UserDefinedTable_UpdateData]
@UserDefinedRowId int,
@UserDefinedFieldId int,
@FieldValue NVarChar(max)
AS
DELETE FROM dbo.[UserDefinedData]
WHERE UserDefinedFieldId = @UserDefinedFieldId
AND UserDefinedRowId = @UserDefinedRowId
IF @FieldValue NOT LIKE ''
INSERT INTO dbo.[UserDefinedData]
( UserDefinedFieldId, UserDefinedRowId, FieldValue)
VALUES (@UserDefinedFieldId, @UserDefinedRowId,@FieldValue)
GO
It should read DELETE FROM {databaseOwner}[{objectQualifier}UserDefinedData]
It should read INSERT INTO {databaseOwner}[{objectQualifier}UserDefinedData]
etc...
Every stored procedure in that file is missing the {databaseOwner}[{objectQualifier}] declaration.