Re: Multiple databases

From: "Nielsen-PM Associates, Inc." <support@npma.com> > >The application we developed has the ability to connect to the database >on the designated server based on an environment variable name. Thus, >users can have multiple databases on the same server, even within the >same instance for IDS. > >We wonder if others with a similar setup might have devised a >user-friendly interface for selecting the desired database. Currently, >we just instruct the user to set the environment variable as part of >their OS; we have other methods in mind, but would like to know if there >are already tried-and-proven approaches. Read the sysdatabases table in the sysmaster database? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com