Browse through list of databases on server
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hi, I would like to allow users of my ADO.NET application to browse through a list of the available databases on a given SQL server. INFORMATION_SCHEMA in SQL Server Books Online doesn't describe how to do this. How can I do this? TIA, Royce
select [name] from master.dbo.sysdatabases
See MSDN: sysdatabases[^] - also available in the Books On-line with SQL Server.