Database creation


Author
Message
Ian Hammond
Ian Hammond
StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)
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.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search