SQL Server Performance

Run Stored procedure

Discussion in 'Performance Tuning for DBAs' started by MRH, Feb 3, 2007.

  1. MRH New Member

    I want to run a stored procedure from an access project module when I do it
    I receive this error message: [OLE/DB provider returned message: New
    transaction cannot enlist in the specified transaction coordinator. ]

    Does anyone know how to solve this problem?
  2. satya Moderator

    Check MSDTC is on or not?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page