RE: How to get all databases name from server
If you're uncomfortable hitting directly against a system table, there is also sp_helpdb with no parameters. However, sp_helpdb will give you more information than it looks like you need. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-07-07