OLENotes in Directory - Back Track all tables they are from.
Posted on 2011-05-12
I have a directory on the network that contains all the OLENotes (attachments) from Dynamics. After extensive research, i have only identified only a few tables that contains the NOTEINDX value i need that ties back to the SY03900 table. The tables i have identified are: RM00101. SOP30200, IV00101 and POP30300.
Using the convert binary(binary(),Cast(dbo...)) function, i can identify the file names that are stored on the network by using the NOTEINDX value from the SY03900 table. I currently have over 20,000 files in the OLENotes folder. I now need to back track to the tables they are referenced to so i can get the information (Data side) that is associated to that attachment.
So basicallly, i should be able to tie back each of the files (20,000 +) to an assoicated table.