Dr. Bill,
>We have created several MM based business objects that update our SQL server 2000. The business objects or coordinated by a winform. The form is used to convert data from an existing database to a new data structure in a new database on a new server.
>
>The problem we are having is consistent behavior. The program will run fine for several hours converting a great deal of data and writing it to the server when suddenly the server stops responding.
Do you get any errors on the workstation? Are there any errors in the SQL Server error logs? What happens if you run the code on the server box?
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com