Home Forums SQL Server 7,2000 T-SQL sp_MSForeachdb then sp_MSforeachtable RE: sp_MSForeachdb then sp_MSforeachtable

  • I have something similar to what you've created (I'll admit, your's is better looking!) using two cursors, one for the database and then one for the table names.

    Then I kept reading about the undocumented stored procs and also about how cursors are BAD and started to fool around with the FOREACH sprocs. Didn't think about reusing the same substitution characters. I bet that's a huge part of my problem. Is any substitution characther valid? I appreciate the response. Thanks.

    -- You can't be late until you show up.