Hi,
I want to search the repository to find all the documents that have a query with the option ‘‘do not generate sql before running’’
I can’t find which table has this information.
Any ideas? thanks,
Lia
:?
Lia 
(BOB member since 2004-08-24)
This information (I believe) is not be stored in the repository tables. The Business Objects documents are stored as BLOBs (binary large objects).
You might have to retrieve all documents from Corporate Documents to you local drive and utilize some VBA macro to “scan” thru the data providers of each Business Objects document (if possible at all).
See also this thread.
Andreas 
(BOB member since 2002-06-20)
Is there anyone who has such a script?
Lia (BOB member since 2004-08-24)
Andreas’ suggestion regarding a VBA macro is a good thought, but in this case it’s not going to help. The “Do not regenerate SQL” setting is not a property that is visible to the object model.
One possibility is to create a clone of the data provider (similar to the code in this utility), and compare the resulting SQL to the original. This would be tedious to code, and even then may work for simple data providers, but is unlikely to work for more complex ones.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)