Error in query The operation could not be performe

• matt.cooke

  Grasshopper

  Points: 17

  More actions

  October 18, 2007 at 10:05 pm

  #183081

  I am getting an error when running the below code,

  EXEC sp_addlinkedserver @server = N'teamserver', @srvproduct = N'SQL SERVER'

  EXEC sp_addlinkedsrvlogin 'teamserver', 'false','sa','sa','vision'

  exec teamserver...xp_servicecontrol 'QUERYSTATE', 'SQLServerAgent'

  create table #sqlstatus(status nvarchar(20))

  insert into #sqlstatus (status) exec teamserver...xp_servicecontrol 'QUERYSTATE', 'SQLServerAgent'

  if exists (select * from #sqlstatus where status='Stopped.')

  exec sqlserver...xp_servicecontrol 'START', 'SQLServerAgent'

  drop table #sqlstatus

  the error is

  Database name 'teamserver' ignored, referencing object in tempdb.

  [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

  OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

  Msg 7391, Level 16, State 1, Line 1

  The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

  has any one got any idea's on what might be causing it ?

  thanks in advance

  ps the sql server is MSDE

• Camilo Torres

  SSCrazy

  Points: 2034

  More actions

  October 23, 2007 at 6:17 am

  #744460

  http://support.microsoft.com/kb/816701