I had several of these during a database copy from SQL 2000 to SQL 2005. Any
ideas on a cause? The second one happened once during the copy and looks like
it was referring to a database that wasn't part of the copy and shouldn't
have been referenced by the other ones.

Event log follows:
Event Name: OnError
Message: An exception occurred while executing a Transact-SQL statement or
batch.
StackTrace: at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
sqlCommand)
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.CreateObject(String database, String script)
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferJobs(DatabaseObject dbObject)
InnerException-->Incorrect syntax near 'SERVER1'.
StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
Operator: NT AUTHORITY\SYSTEM
Source Name: SERVER1_SERVER1_Transfer Objects Task
Source ID: {F70ECB1F-93A5-4933-8621-D2A840D83BAA}
Execution ID: {766A7CC7-C1DD-404D-BA3B-F74FB9B2A126}
Start Time: 12/27/2005 5:39:11 PM
End Time: 12/27/2005 5:39:11 PM
Data Code: 0

2nd event:

Event Name: OnError
Message: An exception occurred while executing a Transact-SQL statement or
batch.
StackTrace: at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection sqlCommands)
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.CreateObject(String database, StringCollection script)
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferJobs(DatabaseObject dbObject)
InnerException-->The specified @database_name ('SOE') does not exist.
StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String
methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
Operator: NT AUTHORITY\SYSTEM
Source Name: CDW_SERVER1_SERVER2_2
Source ID: {027FD3A2-54DF-4BF3-BCF9-BA7A3CFCC92D}
Execution ID: {766A7CC7-C1DD-404D-BA3B-F74FB9B2A126}
Start Time: 12/27/2005 5:39:11 PM
End Time: 12/27/2005 5:39:11 PM
Data Code: 0


--
R Johnson
Michigan