[dba-SQLServer]Simple way to get databases like myDB* into a combo box?

Arthur Fuller artful at rogers.com
Mon Feb 24 12:35:27 CST 2003


It only took one line of SQL, sorry to bother you with my laziness.
SELECT Name FROM master.dbo.sysdatabases WHERE CharIndex( 'Arthur', Name ) >
0 
ORDER BY Name
Doh!

-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: February 24, 2003 1:23 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer]Simple way to get databases like myDB* into a combo
box?

I want to drop a list like that into an Access combo-box. I.e. several dbs
of similar names may be opened. Grab the selection, modify the connection.
Anyone got this function in the can? 
Just thought I'd ask before writing it :-)
TIA,
Arthur


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list