what is the best practice on cataloging report queries for reuse?
I have been tasked to catalog all SQL scripts, routines and queries used to generate report for management within our organization. Is there a best practice out there to mimic or does anyone have suggestions or recommendation on how to accomplish the task at hand?
I would strongly suggest getting much better definitions of exactly what it is that they're looking for. Simply a catalogue of scripts is unlikely to tell anyone anything. You can easily generate this using a query against the objects list in your databases. For a detailed documentation of objects within SQL Server, I'd suggest looking [at this tool] from Red Gate. It'll help you lay things out, but it may still not be what you're looking for. Disclaimer: I work for Redgate. :