Group: Forum Members
Posts: 57,
Visits: 277
|
I am attempting to create my database, but I get an exception:
Ensuring Tables exist on database 'HLS' X 04/04/2011 12:00:28 -> Creating table 'HLS' failed. X 04/04/2011 12:00:28 -> FailedOperationException X 04/04/2011 12:00:28 -> Create failed for Table 'dbo.HLS'. X 04/04/2011 12:00:28 -> ExecutionFailureException X 04/04/2011 12:00:28 -> An exception occurred while executing a Transact-SQL statement or batch. X 04/04/2011 12:00:28 -> SqlException X 04/04/2011 12:00:28 -> Incorrect syntax near ','. X 04/04/2011 12:00:28 -> X 04/04/2011 12:00:28 -> Source : Microsoft.SqlServer.Smo X 04/04/2011 12:00:28 -> X 04/04/2011 12:00:28 -> Stack Trace: X 04/04/2011 12:00:28 -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) X 04/04/2011 12:00:28 -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) X 04/04/2011 12:00:28 -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) X 04/04/2011 12:00:28 -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) X 04/04/2011 12:00:28 -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) X 04/04/2011 12:00:28 -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) X 04/04/2011 12:00:28 -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() X 04/04/2011 12:00:28 -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 04/04/2011 12:00:28 -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 04/04/2011 12:00:28 -> at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries) X 04/04/2011 12:00:28 -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext) X 04/04/2011 12:00:28 -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so) X 04/04/2011 12:00:28 -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl() X 04/04/2011 12:00:28 -> at Microsoft.SqlServer.Management.Smo.Table.Create() X 04/04/2011 12:00:28 -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateSmoObject(ICreatable ObjectToCreate, String ObjectName, DBEObjectType ObjectType, Boolean verboseLogging) X 04/04/2011 12:00:28 ->
Is there anyway I ccan see what Transact coomand is used to create the database table?
Are there any pointers to waht I may be doing wrong?
Many thanks.
|