Second Amended and Restated Agreement of Limited Partnership Dated as of October 1, 2004