Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Returning All Databases/Usernames/Passwords on the Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-08 : 08:38:18
Ken writes "I'd like to run a script that will load the following info into a two-dimensional array that I can work with in VBScript:

For each database on server:
array(0) = Name of database
array(1) = username
array(2) = password
next

I've got an ASP-based database management tool, but it requires me to hand-code a connection string for each database in my SQL Server. No way.. I've got too many! :-)

Thanks in advance.

I'm running IIS4 on NT with SQL Server 7.0 sp3 behind it."
   

- Advertisement -