How to export stored procedures from sqlserver2000 to ms access

[srinivassam]

Hi all, i have one doubt , i want to export stored procedures data from sqlserver2000 to ms access, give me any idea . thanks & regards sarp

sarp

[Ashfield]

You will probably need to rewrite them as Access does not use the same syntax as SQL Server in many instances. You can export stored procs from enterprise manager by scripting them as create, but I doubt it will help.

Bob Ashfield Consultants Ltd

[Vasudevan Deepak Kumar]

The SQL to Access transition would relatively require a manual intervention at least with respect to Stored Procedures.

Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson