I was thinking I could look at sys.objects and sys.columns to get a list of tables and names and then use a cursor to loop through it all.

T-SQL Populating local variables from cursor rluciano Jul 10, 2007 Jump to latest Follow Reply ...