Hi to all, I need some help finding a problem with a SQL script for removing a table from the DotNetNuke database. I have trialled the script from inside SQL Management Studio and it works fine. But when I tried to run the script on my development website I get the following error.

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '('. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 ConnectionString, String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String connectionString, String script) IF EXISTS (SELECT * FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'(databaseowner)[(ObjectQualifier)TaskManager_Task]') AND type in (N'U')) DROP TABLE (databaseowner)[(objectqualifier)TaskManager_Task]

this is the script,

IF EXISTS (SELECT * FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'(databaseowner)(ObjectQualifier)TaskManager_Task]') AND type in (N'U'))
DROP TABLE (databaseowner)[(objectqualifier)TaskManager_Task]

any help would be appreciated as I am no expert on either SQL for DotNetNuke.

With anticipation

regards

Trevor