Currently the database is in Suspect mode. I am not interested in getting the data. but want to all table, view, functions and SP definitions out. Just wondering if there any easy way out as restoring of DB is not a viable option at this point of time. Data can be ETLed in. Thanks.
If you're only interested in capturing the structures and you don't care about any of the data, you can try dropping the table from the DAC connection. No guarantees that it will work, but you can try. If it fails, chances are you need to go through recovery.