If you have Multiple Application Databases is it possible to set up quick query where it searches across multiple application databases instead of just the one you are logged into?
*This post is locked for comments
Did you tried updating System..QVCATALOG.CompanyParms with 2?
CompanyParms = 2 will show information from all Companies for which the User has permissions
You could probably write a view that looks at the various dbs and unions the data. The fun is going to come in in getting it installed with security and the menus. The last time I attempted something remotely like it, I was joining a table from the sys db. It would run for administrators but not anyone else. I never did get it tweaked in because I ran out of time and moved on. YMMV.
...b
Share
Report
All responses (
Answers (
192
