Cathi,
I would apperciat it if you can send me the SQL Server procedures. It will help me tremendously. Thank you.
>>Hi all,
>> Does anyone know what I need to do in order to move my data into SQL backend. I have sucessfully move some of the tables and create remote view and it works fine except when I add new record that i use the NEWID() function. I guess my question is more of what I need to do to move the the system table to SQL as well and what local and remote views I will have to create for each of these tables. Thanks in advance for any comments or help.
>>
>
>In thread #
370622, James talks about how to convert your existing local views to remote views that work properly in SQL Server and MMF. In addition, you will need to add procedural code in SQL Server to generate unique IDs. I will be glad to email you the SQL Server procedures that I use.
The best way to learn is to jump in and find out.