MS SQL Data Warehousing - Check syntax of stored procs and views-sp

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Check syntax of stored procs and views-sp_grep

Ryanfaf via SQLMonster.com

2005-09-19, 1:24 pm

Hello,

Does anyone know of a good way to check the contents of stored procs and
views within a SQL Server 2000 database for key words? I need to pass each
name from a list of over 1000 table names through this process and would like
to find a shortcut. I've used a procedure called sp_grep in the past for
this type of thing, but I'd like to avoid manually running the proc for each
keyword. Can a cursor be used to pass the contents of a list through sp_grep
one by one?

Any help would be graciously appreciated.

Sponsored Links