reading files programmatically
Posted on 2006-11-16
I have to go through the text of a bunch of stored procedures looking for other objects that they reference. For example: the text that follows the word "exec" is a name of a stored procedure, one after words like "insert", "delete" refer to a table.
can some one give me an idea what is the easiest way to accomplish the task of going throgh all these files and retrieving the necessary information?