[thelist] Laptop - Web Design Wishlist

Paul Bennett paul at teltest.com
Wed Sep 17 20:23:03 CDT 2003


Tim Burgan wrote:

>
>What would be people's DREAM setup though.
>
a 2.5GHz pda/phone with 19" projection screen, wireless DSL,  and a link 
right into my head so I don't have to type

ok, ok tip owed...

<tip type="sql server - listing all databases">
If you ever need to list the databases in SQL Server (7.0 and 2000 I 
think) use this query:

"select CATALOG_NAME from INFORMATION_SCHEMA.SCHEMATA"

running the query results through a loop will give you a nice db list


</tip>

>
>  
>


-- 
 ------------------------------
	Paul Bennett						
	Internet Developer				
	Teltest Electronic Design		
 ------------------------------			
Email: paul at teltest.com				
Phone: 64 4 237 4557					
Web: http://www.teltest.com		
Wap: http://wap.teltest.com			




More information about the thelist mailing list