Then possible problems due to incompatable updates of the existing SPs and views are avoided by the creation our own SPs. In message 711146 I showed a good solution I made to the origional problem. However, Michael, you have brought up an interesting point.
Are the MS SPs, veiws etc documented yet unsupported? I'm flashing back to API calls and DBF header layouts...
Joe.
>While the system tables do contain a wealth of information, Microsoft does not recommend directly reading from them.
Microsoft has warned that it might change the structure of the system tables at any release.
>
>You would be better working from the various system stored procedures, functions, and information_schema views. All of which will be maintained by MS regardless of the changes to the system tables.
>
>-Mike
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams
