<div>
Hi Fabian,
</div><div><br></div><div>I think </div><div>show databases</div><div>is the closed you will get.</div><div><br></div><div>This returns the name of the registered databases. </div><div>On the other hand you can always define a property on the database that stores the path as a workaround and combine show database with property 'full_path' of database x</div><div><br></div><div>hth,</div>
<div><div><br></div><div>-- </div><div>Bart Pietercil</div><div>CTO Cognosis NV</div><div>Dorpstraat 28</div><div>3560 Lummen<br></div><div><br></div></div>
<p style="color: #A0A0A8;">On Thursday 17 May 2012 at 16:56, Fabian Kneubuehl wrote:</p>
<blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px;">
<span><div><div><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 14 (filtered medium)"><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--><div><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Hi,<o:p></o:p></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><o:p> </o:p></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span lang="EN-US">Is it possible to retrieve all registered databases in VServer (names and full paths) via SQL?<o:p></o:p></span></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span lang="EN-US"><o:p> </o:p></span></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="mso-fareast-language:DE-CH">Regards<o:p></o:p></span></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="mso-fareast-language:DE-CH">Fabian </span><span style="font-size:9.0pt;mso-fareast-language:DE-CH"><o:p></o:p></span></p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><o:p> </o:p></p></div></div><div><div>_______________________________________________</div><div>Valentina mailing list</div><div><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a></div><div><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a></div></div></div></span>
</blockquote>
<div>
<br>
</div>