oSQLServer = CREATEOBJECT("SQLDMO.SQLServer") oSQLServer.Connect(".","userid","password") dmoDatabase = CreateObject("SQLDMO.Database2") dmoDBFile = CreateObject("SQLDMO.DBFile") dmoLogFile = CreateObject("SQLDMO.LogFile") dmoDatabase.NAME = "Test DataBase" dmoDatabase.collation = "SQL_Latin1_General_CP1_CI_AS" dmoDBFile.NAME = "Test DataBase" dmoDBFile.PhysicalName = "C:\TEST.mdf" dmoDBFile.PrimaryFile = .T. dmoDatabase.FileGroups("PRIMARY").DBFiles.ADD(dmoDBFile) dmoLogFile.Name = "TEST.log" dmoLogFile.PhysicalName = "C:\TEST.ldf" dmoDatabase.TransactionLog.LogFiles.ADD(dmoLogFile) oSQLServer.DATABASES.ADD(dmoDatabase) * now add the default dmoDefault = CreateObject("SQLDMO.Default") dmoDefault.Name = 'UW_ZeroDefault' dmoDefault.Text = '0' dmoDatabase.Defaults.Add(dmoDefault) && error occurs here! dmoDefault = .F.when the code reaches the ADD(DmoDefault) line it errors out with a :
OLE IDispatch exception code 207 from Microsoft SQL-DMO (ODBC SQLState 42s22) "Invalid Column name 'id'."Has anybody got any ideas what this could be, again this works fine under sql server 2000.