>>>>>Thank you.
>>>>>
>>>>There may be situations when it's not a good choice to let it create clustered index by default and better to make it non-clustered. Say, if your PK is uniqueidentifier and you didn't specify NewSequentialID() as default value.
>>>
>>>I will have to think about this one to understand. Thank you.
>>
>>Take a look at this blog post to understand better
>>
>>http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/best-practice-don-t-not-cluster-on-uniqu
>
>Thank you. I will later; right now my priority is to resolve the Transaction issue.

Start from writing the whole code as one batch in SSMS. Once you get it working there, you can use the same batch in VFP.