title: C# SQL Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction
body: <p>I'm getting this error (Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.) when trying to run a stored procedure from C# on a SQL Server 2005 database.  I'm not actively/purposefully using transactions or anything, which is what makes this error weird.  I can run the stored procedure from management studio and it works fine.  Other stored procedures also work from C#, it just seems to be this one with issues.  The error returns instantly, so it can't be a timeout issue.  The code is along the lines of:</p>
  
  <pre><code>  SqlCommand cmd = null;
    try
    {
        // Make sure we are connected to the database
        if (_DBManager.CheckConnection())
        {
          cmd = new SqlCommand();
  
          lock (_DBManager.SqlConnection)
          {
            cmd.CommandText = "storedproc";
            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            cmd.Connection = _DBManager.SqlConnection;
  
            cmd.Parameters.AddWithValue("@param", value);
  
            int affRows = cmd.ExecuteNonQuery();
  
            ...
          }
        }
        else
        {
          ...
        }
    }
    catch (Exception ex)
    {
      ...
    }
  </code></pre>
  
  <p>It's really got me stumped.  Thanks for any help</p>