Given a Parent ID, what is the best way to return all child records, their child records, ad inifitum? I needed this to find all employees beneath a given manager no matter how deep.

Post in

I keep saying this, but I can't believe I have been programming in Sql Server for this many years, and never heard of templates. While in Query Analyzer, hit Ctrl-Shift-Ins.

Shrinking the transaction log was so very easy once I figured it out.  All you need to do: 1. Backup your database just in case. 2. Run the following. If your database is called “Vampires”, then Database name will be “Vampires” and most likely your log file will be “Vampires_Log”: USE <DATABASE NAME> BACKUP LOG <DATABASE…