Thanks Thomas,

yes, it's sloppy. My disclaimer: I got this off a Microsoft site and it is just a quick and dirty utility used every now and then but it has worked for ages at numerous sites. :) I only added in the Console.WriteLine() as a quick means to see if it was even reaching the first line, but it isn't, so I guess it is some missing or incorrect version of something the code needs.

>Frank,
>
>not directly helping on the error, but perhaps in a roundabut way eliminating some vague points: that is sloppy coding! Either create a 2-line method adding one tabledesc depending on a parameter or build a list of names and loop over them. Benefit lies in the option to add code like logging to each processed name easily...
>
>HTH
>
>thomas
>
>
>>I have the following code compiled into en executable and running successfully at multiple sites. At one site in particular the exe just crashes without any error displaying, just a notice from Windows that the exe has crashed. The Event Log shows this:
>>
>>Faulting application ProvisionClient.exe, version 1.0.0.0, time stamp 0x53408368, faulting module System.EnterpriseServices.Wrapper.dll, version 4.0.30319.18408, time stamp 0x5231093c, exception code 0xc0000005, fault offset 0x00015d65, process id 0x%9, application start time 0x%10.
>>
>>This is my code, any ideas what I can do to work out what is going wrong?
>>
>>

using System;
>>using System.Collections.Generic;
>>using System.Linq;
>>using System.Text;
>>
>>using System.Data;
>>using System.Data.SqlClient;
>>
>>using Microsoft.Synchronization;
>>using Microsoft.Synchronization.Data;
>>using Microsoft.Synchronization.Data.SqlServer;
>>
>>using System.Configuration;
>>using System.IO;
>>
>>namespace ProvisionServer
>>{
>>    class Program
>>    {
>>        static void Main(string[] args)
>>        {
>>            try
>>            {
>>                Console.WriteLine("Getting connection string");
>>                string serverConnection = ConfigurationManager.ConnectionStrings["Server"].ConnectionString;
>>
>>                // connect to server database
>>                Console.WriteLine("connect to server database");
>>                SqlConnection serverConn = new SqlConnection(serverConnection);
>>
>>                // define a new scope named CompleteScope
>>                DbSyncScopeDescription scopeDesc = new DbSyncScopeDescription("CompleteScope");
>>
>>                // add the description of all the tables from the database
>>                //DbSyncTableDescription tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Accounts", serverConn);
>>
>>                // add the table description to the sync scope definition
>>                //scopeDesc.Tables.Add(tableDesc);
>>
>>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("AccountTypes", serverConn);
>>                //scopeDesc.Tables.Add(tableDesc);
>>
>>                DbSyncTableDescription tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("AppConfig", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ApptTypes", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Attendance", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("AttendanceDetails", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Branches", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("CLLabOrder", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("CLTrials", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("CreditNotes", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Discounts", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Drawings", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ErrorLog", serverConn);
>>                //scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ExamDiagnoses", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ExamLensType", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Exams", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Holidays", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ItemCategories", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Items", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("LabOrderLensType", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("LabOrders", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Letters", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("LoginHistory", serverConn);
>>                //scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Lookups", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("LookupTypes", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("MemoAE", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("MsgSvc", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Navigator", serverConn);
>>                //scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PatientAddresses", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PatientEmails", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PatientPhones", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PatientRecallPlans", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Patients", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Payments", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("PaymentsDetails", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("RecallDetails", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("RecallNotices", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("RecallPlans", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Recalls", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("RefundDetails", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Refunds", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("ReportCatalog", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Sales", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("SalesDetails", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Schedule", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("SecuredItems", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("SecurityAccess", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("StockReceipts", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Transfers", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("UserAccExceptions", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("UserGroups", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                //tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("UserPrefs", serverConn);
>>                //scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Users", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("UsrGrpXRef", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Vacation", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("VAT", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("Vendors", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("VFPCommands", serverConn);
>>                scopeDesc.Tables.Add(tableDesc);
>>
>>                // create a server scope provisioning object based on the ProductScope
>>                SqlSyncScopeProvisioning serverProvision = new SqlSyncScopeProvisioning(serverConn, scopeDesc);
>>
>>                // skipping the creation of table since table already exists on server
>>                serverProvision.SetCreateTableDefault(DbSyncCreationOption.Skip);
>>
>>                // start the provisioning process
>>                serverProvision.Apply();
>>            }
>>            catch (Exception error)
>>            {
>>                using (StreamWriter tw = new StreamWriter("BPOSync.log", true))
>>                {
>>                    // write a line of text to the file
>>                    tw.WriteLine(DateTime.Now);
>>                    tw.WriteLine("Error");
>>                    tw.WriteLine(error.ToString());
>>                    //tw.WriteLine(error.InnerException); 
>>                    tw.WriteLine("---");
>>
>>                    // close the stream
>>                    tw.Close();
>>                }
>>            }
>>        }
>>    }
>>}