Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Read SQL Stored Procedure definitions via Access

Author  Topic  bwillsie Starting Member 1 Post Posted - 2008-09-18 : 09:47:10 Anyone know an easy way to read the complete definitions of SQL Server Stored Procedures, triggers, etc. via MS Access. I can connect to the tables containing the stored procedures, etc. via ODBC & Access, but I don't see the complete definition, only small snippets of code that are neither the beginning nor end of the objects. I want to use this process for auditing stored procedures, etc. as the ODBC connnection is set up as read only. Thanks, Bobw