Hello everyone,

I'm developing my DNN site on VS2008, SQLServer 2005 (Database on Server, not local .mdf file).

I'm having problems with the creation of the tables.

The execution of the scripts for creating tables during the installation, fails.
I've tried to execute the query manually, but I had the same errors.

Hope someone could help.

Greetings.

Are you getting errors when you try to install ADefHelpDesk?

Can you post the exact error?

Yes, during installation. The installation ends successfully, but the tables are not created (reported on the install log too):

StartJob Begin Sql execution
Info Executing 00.10.00.SqlDataProvider
StartJob Start Sql execution: 00.10.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Riga 27: sintassi non corretta in prossimità di '('. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

....and so on for the other tables too

What are your SQL Server Collation setting for the database set to? It has only been tested with: SQL_Latin1_general_CP1_CI_AS

Other than that I have no idea why it wont work for you. It has been installed successfully by hundreds of users for nearly a year.

the collation setting for the database I'm using is:

Latin1_General_CI_AS

does it cause known problems?

the collation setting for the database I'm using is:

Latin1_General_CI_AS

That should be fine.

You also indicated that "I'm developing my DNN site on VS2008". Did you perform some action that would have saved the .sql files in a format other than UTF-8 format? Perhaps you copied them into Visual Studio?

To test this, try running the contents of the .sql files directly in SQL server. If they work there, then the encoding in the .sql files has been altered.

If you are just uploading the .zip install file using the normal DotNetNuke install process described in the Documentation on this site, you will not have this problem.

I've installed the module using the DNN install process, and then tried to create the tables copying the content of the SqlDataProvider files in a "New Query" window in SQL Server.

Executing the query, I've got the same errors (eg. Row 27: Incorrect syntax "("....)

Maybe the queries are altered?

I just downloaded the 02.00.00 version and installed it, and it installs fine.

Is your dotnetnuke installed using a database owner other than .dbo? This module will only work if you have the sql database user as "dbo" (database owner).

Yes, is database owner "dbo"

Please post the .sql script that you are running that is not working.

Thank You

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_LastSearch]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_LastSearch](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[PortalID] [int] NOT NULL,
[SearchText] [nvarchar](150) NULL,
[Status] [nvarchar](50) NULL,
[Priority] [nvarchar](50) NULL,
[CreatedDate] [datetime] NULL,
[DueDate] [datetime] NULL,
[AssignedRoleID] [int] NULL,
[Categories] [nvarchar](2000) NULL,
CONSTRAINT [PK_ADefHelpDesk_LastSearch] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_LastSearch]') AND name = N'IX_ADefHelpDesk_LastSearch')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_LastSearch] ON [dbo].[ADefHelpDesk_LastSearch]
(
[UserID] ASC,
[PortalID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Categories]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_Categories](
[CategoryID] [int] IDENTITY(1,1) NOT NULL,
[PortalID] [int] NOT NULL,
[ParentCategoryID] [int] NULL,
[CategoryName] [nvarchar](50) NULL,
[Level] [int] NOT NULL,
[RequestorVisible] [bit] NOT NULL,
[Selectable] [bit] NOT NULL,
CONSTRAINT [PK_ADefHelpDesk_Categories] PRIMARY KEY CLUSTERED
(
[CategoryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Categories]') AND name = N'IX_ADefHelpDesk_Categories')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Categories] ON [dbo].[ADefHelpDesk_Categories]
(
[PortalID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Settings]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_Settings](
[SettingID] [int] IDENTITY(1,1) NOT NULL,
[PortalID] [int] NOT NULL,
[SettingName] [nvarchar](150) NOT NULL,
[SettingValue] [nvarchar](250) NOT NULL,
CONSTRAINT [PK_ADefHelpDesk_Settings] PRIMARY KEY CLUSTERED
(
[SettingID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Settings]') AND name = N'IX_ADefHelpDesk_Settings_PortalID')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Settings_PortalID] ON [dbo].[ADefHelpDesk_Settings]
(
[PortalID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Roles]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_Roles](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PortalID] [int] NOT NULL,
[RoleID] [int] NOT NULL,
CONSTRAINT [PK_ADefHelpDesk_Roles] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Roles]') AND name = N'IX_ADefHelpDesk_Roles')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Roles] ON [dbo].[ADefHelpDesk_Roles]
(
[PortalID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Tasks]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_Tasks](
[TaskID] [int] IDENTITY(1,1) NOT NULL,
[PortalID] [int] NOT NULL,
[Description] [nvarchar](150) NOT NULL,
[Status] [nvarchar](50) NOT NULL,
[Priority] [nvarchar](50) NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[EstimatedStart] [datetime] NULL,
[EstimatedCompletion] [datetime] NULL,
[DueDate] [datetime] NULL,
[AssignedRoleID] [int] NOT NULL,
[TicketPassword] [nvarchar](50) NOT NULL,
[RequesterUserID] [int] NOT NULL,
[RequesterName] [nvarchar](350) NULL,
[RequesterEmail] [nvarchar](350) NULL,
[RequesterPhone] [nvarchar](50) NULL,
[EstimatedHours] [int] NULL,
CONSTRAINT [PK_ADefHelpDeskTasks] PRIMARY KEY CLUSTERED
(
[TaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Tasks]') AND name = N'IX_ADefHelpDesk_Tasks_AssignedRoleID')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Tasks_AssignedRoleID] ON [dbo].[ADefHelpDesk_Tasks]
(
[AssignedRoleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Tasks]') AND name = N'IX_ADefHelpDesk_Tasks_CreatedDate')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Tasks_CreatedDate] ON [dbo].[ADefHelpDesk_Tasks]
(
[CreatedDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Tasks]') AND name = N'IX_ADefHelpDesk_Tasks_Status')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Tasks_Status] ON [dbo].[ADefHelpDesk_Tasks]
(
[Status] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskDetails]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_TaskDetails](
[DetailID] [int] IDENTITY(1,1) NOT NULL,
[TaskID] [int] NOT NULL,
[DetailType] [nvarchar](50) NOT NULL,
[InsertDate] [datetime] NOT NULL,
[UserID] [int] NOT NULL,
[Description] [nvarchar](max) NOT NULL,
[StartTime] [datetime] NULL,
[StopTime] [datetime] NULL,
CONSTRAINT [PK_ADefHelpDesk_TaskDetails] PRIMARY KEY CLUSTERED
(
[DetailID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskDetails]') AND name = N'IX_ADefHelpDesk_TaskDetails')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_TaskDetails] ON [dbo].[ADefHelpDesk_TaskDetails]
(
[TaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskCategories]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_TaskCategories](
[ID] [int] IDENTITY(1,1) NOT NULL,
[TaskID] [int] NOT NULL,
[CategoryID] [int] NOT NULL,
CONSTRAINT [PK_ADefHelpDesk_TaskCategories] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskCategories]') AND name = N'IX_ADefHelpDesk_TaskCategories')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_TaskCategories] ON [dbo].[ADefHelpDesk_TaskCategories]
(
[TaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskAssociations]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_TaskAssociations](
[TaskRelationID] [int] IDENTITY(1,1) NOT NULL,
[TaskID] [int] NOT NULL,
[AssociatedID] [int] NOT NULL,
CONSTRAINT [PK_ADefHelpDesk_TaskAssociations] PRIMARY KEY CLUSTERED
(
[TaskRelationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskAssociations]') AND name = N'IX_ADefHelpDesk_TaskAssociations')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_TaskAssociations] ON [dbo].[ADefHelpDesk_TaskAssociations]
(
[TaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Log]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_Log](
[LogID] [int] IDENTITY(1,1) NOT NULL,
[TaskID] [int] NOT NULL,
[LogDescription] [nvarchar](500) NOT NULL,
[DateCreated] [datetime] NOT NULL,
[UserID] [int] NOT NULL,
CONSTRAINT [PK_ADefHelpDesk_Log] PRIMARY KEY CLUSTERED
(
[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Log]') AND name = N'IX_ADefHelpDesk_Log')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Log] ON [dbo].[ADefHelpDesk_Log]
(
[TaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Attachments]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_Attachments](
[AttachmentID] [int] IDENTITY(1,1) NOT NULL,
[DetailID] [int] NOT NULL,
[AttachmentPath] [nvarchar](1000) NOT NULL,
[FileName] [nvarchar](150) NOT NULL,
[OriginalFileName] [nvarchar](150) NOT NULL,
[UserID] [int] NOT NULL,
CONSTRAINT [PK_ADefHelpDesk_Attachments] PRIMARY KEY CLUSTERED
(
[AttachmentID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Attachments]') AND name = N'IX_ADefHelpDesk_Attachments')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Attachments] ON [dbo].[ADefHelpDesk_Attachments]
(
[DetailID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_Attachments_ADefHelpDesk_TaskDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Attachments]'))
ALTER TABLE [dbo].[ADefHelpDesk_Attachments] WITH CHECK ADD CONSTRAINT [FK_ADefHelpDesk_Attachments_ADefHelpDesk_TaskDetails] FOREIGN KEY([DetailID])
REFERENCES [dbo].[ADefHelpDesk_TaskDetails] ([DetailID])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_Attachments_ADefHelpDesk_TaskDetails]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Attachments]'))
ALTER TABLE [dbo].[ADefHelpDesk_Attachments] CHECK CONSTRAINT [FK_ADefHelpDesk_Attachments_ADefHelpDesk_TaskDetails]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_Log_ADefHelpDesk_Tasks]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Log]'))
ALTER TABLE [dbo].[ADefHelpDesk_Log] WITH CHECK ADD CONSTRAINT [FK_ADefHelpDesk_Log_ADefHelpDesk_Tasks] FOREIGN KEY([TaskID])
REFERENCES [dbo].[ADefHelpDesk_Tasks] ([TaskID])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_Log_ADefHelpDesk_Tasks]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Log]'))
ALTER TABLE [dbo].[ADefHelpDesk_Log] CHECK CONSTRAINT [FK_ADefHelpDesk_Log_ADefHelpDesk_Tasks]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_TaskAssociations_ADefHelpDesk_Tasks]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskAssociations]'))
ALTER TABLE [dbo].[ADefHelpDesk_TaskAssociations] WITH CHECK ADD CONSTRAINT [FK_ADefHelpDesk_TaskAssociations_ADefHelpDesk_Tasks] FOREIGN KEY([TaskID])
REFERENCES [dbo].[ADefHelpDesk_Tasks] ([TaskID])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_TaskAssociations_ADefHelpDesk_Tasks]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskAssociations]'))
ALTER TABLE [dbo].[ADefHelpDesk_TaskAssociations] CHECK CONSTRAINT [FK_ADefHelpDesk_TaskAssociations_ADefHelpDesk_Tasks]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_TaskCategories_ADefHelpDesk_Categories]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskCategories]'))
ALTER TABLE [dbo].[ADefHelpDesk_TaskCategories] WITH CHECK ADD CONSTRAINT [FK_ADefHelpDesk_TaskCategories_ADefHelpDesk_Categories] FOREIGN KEY([CategoryID])
REFERENCES [dbo].[ADefHelpDesk_Categories] ([CategoryID])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_TaskCategories_ADefHelpDesk_Categories]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskCategories]'))
ALTER TABLE [dbo].[ADefHelpDesk_TaskCategories] CHECK CONSTRAINT [FK_ADefHelpDesk_TaskCategories_ADefHelpDesk_Categories]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_TaskCategories_ADefHelpDesk_Tasks]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskCategories]'))
ALTER TABLE [dbo].[ADefHelpDesk_TaskCategories] WITH CHECK ADD CONSTRAINT [FK_ADefHelpDesk_TaskCategories_ADefHelpDesk_Tasks] FOREIGN KEY([TaskID])
REFERENCES [dbo].[ADefHelpDesk_Tasks] ([TaskID])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_TaskCategories_ADefHelpDesk_Tasks]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskCategories]'))
ALTER TABLE [dbo].[ADefHelpDesk_TaskCategories] CHECK CONSTRAINT [FK_ADefHelpDesk_TaskCategories_ADefHelpDesk_Tasks]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_TaskDetails_ADefHelpDesk_Tasks]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskDetails]'))
ALTER TABLE [dbo].[ADefHelpDesk_TaskDetails] WITH CHECK ADD CONSTRAINT [FK_ADefHelpDesk_TaskDetails_ADefHelpDesk_Tasks] FOREIGN KEY([TaskID])
REFERENCES [dbo].[ADefHelpDesk_Tasks] ([TaskID])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ADefHelpDesk_TaskDetails_ADefHelpDesk_Tasks]') AND parent_object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_TaskDetails]'))
ALTER TABLE [dbo].[ADefHelpDesk_TaskDetails] CHECK CONSTRAINT [FK_ADefHelpDesk_TaskDetails_ADefHelpDesk_Tasks]

When I run the script you posted it runs fine.

Please try to run the following script. I have added the ANSI_NULLS and QUOTED_IDENTIFIER to it:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Tasks]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ADefHelpDesk_Tasks](
[TaskID] [int] IDENTITY(1,1) NOT NULL,
[PortalID] [int] NOT NULL,
[Description] [nvarchar](150) NOT NULL,
[Status] [nvarchar](50) NOT NULL,
[Priority] [nvarchar](50) NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[EstimatedStart] [datetime] NULL,
[EstimatedCompletion] [datetime] NULL,
[DueDate] [datetime] NULL,
[AssignedRoleID] [int] NOT NULL,
[TicketPassword] [nvarchar](50) NOT NULL,
[RequesterUserID] [int] NOT NULL,
[RequesterName] [nvarchar](350) NULL,
[RequesterEmail] [nvarchar](350) NULL,
[RequesterPhone] [nvarchar](50) NULL,
[EstimatedHours] [int] NULL,
CONSTRAINT [PK_ADefHelpDeskTasks] PRIMARY KEY CLUSTERED
(
[TaskID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Tasks]') AND name = N'IX_ADefHelpDesk_Tasks_AssignedRoleID')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Tasks_AssignedRoleID] ON [dbo].[ADefHelpDesk_Tasks]
(
[AssignedRoleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Tasks]') AND name = N'IX_ADefHelpDesk_Tasks_CreatedDate')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Tasks_CreatedDate] ON [dbo].[ADefHelpDesk_Tasks]
(
[CreatedDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ADefHelpDesk_Tasks]') AND name = N'IX_ADefHelpDesk_Tasks_Status')
CREATE NONCLUSTERED INDEX [IX_ADefHelpDesk_Tasks_Status] ON [dbo].[ADefHelpDesk_Tasks]
(
[Status] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

No, sorry. I get the following errors:


Msg 170, Level 15, State 1, Line 23
Riga 23: sintassi non corretta in prossimità di '('. <<< Means: Row 23. Incorrect syntax in proximity of '('
Msg 170, Level 15, State 1, Line 5
Riga 5: sintassi non corretta in prossimità di '('.
Msg 170, Level 15, State 1, Line 5
Riga 5: sintassi non corretta in prossimità di '('.
Msg 170, Level 15, State 1, Line 5
Riga 5: sintassi non corretta in prossimità di '('.

No, sorry. I get the following errors:...

Are you sure you have SQL server 2005 or above?

I am out of ideas

Yes, I've SQL Server 2005 Management Studio Express.

Please let me know if you are able to figure this out.

Thank You

Hi there.

We've solved the issue re-installing SQL Server 2005.

Thanks for helping.

I've got another question:
Is there a function in the module, for deleting all records?

We've solved the issue re-installing SQL Server 2005.

Thank you for following up. It was troubling that we could not figure this out. I wondered how many other people could have gotten this problem.

Is there a function in the module, for deleting all records?

No, we don't even have the uninstall.sql script in the module because we know that it would REALLY be a problem is someone lost all their Help Desk data.

However, You can see these directions to delete a Ticket:
http://adefhelpdesk.com/Documentation/Technical/DeletingTickets/tabid/74/Default.aspx

Resolved, many thanks.