How can I tell which SP is in error when trying to Export?

I am trying to Export a database to another using the export wizard. It
states that it found an invalid column name on one of the stored procedures
but doesn't say WHICH strored procedure, which is problematic since there
are nearly a thousand of them.
Does anyone know how to tell which sp is in error?"Tom" <nfr@.nospam.com> wrote in message
news:uyu4zBFOEHA.204@.TK2MSFTNGP10.phx.gbl...
> I am trying to Export a database to another using the export wizard. It
> states that it found an invalid column name on one of the stored
procedures
> but doesn't say WHICH strored procedure, which is problematic since there
> are nearly a thousand of them.
> Does anyone know how to tell which sp is in error?
There must be Details button I think...
Else it is safe to generate script of all of your procedures (Select them in
EM - all tasks -> generate script) and run it on same database from Query
Analyzer - you will see what is the exact error and where.
Bojidar Alexandrov