Quick Query with Multiple Application Databases

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (0)

Suggested answer

Peter Pino 190 on at

Like (0)

Report

RE: Quick Query with Multiple Application Databases

Did you tried updating System..QVCATALOG.CompanyParms with 2?

CompanyParms = 2 will show information from all Companies for which the User has permissions
Butch Adams 4,761 on at

Like (0)

Report

RE: Quick Query with Multiple Application Databases

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