<div>
you need access to the master database...<br />
<br />
select * from master..sysdatabases<br />

</div>


you need access to the master database...

select * from master..sysdatabases


<div>
Used SQL-DMO which provide extensibly feature to manage complete server.<br />

</div>


Used SQL-DMO which provide extensibly feature to manage complete server.


<div>
<a href="http://www.csharphelp.com/archives2/archive342.html" rel="ugc">http://www.csharphelp.com/archives2/archive342.html</a><br />
<br />
tried to look this link may be you will get u r answer .......cheers!!!!!!!!!!<br />
<br />

</div>


http://www.csharphelp.com/archives2/archive342.html [http://www.csharphelp.com/archives2/archive342.html]

tried to look this link may be you will get u r answer .......cheers!!!!!!!!!!



<div>
a wise expert once said to use master views rather than tables wherever poss:<br />
<br />
SELECT [CATALOG_NAME]<br />
FROM [master].[INFORMATION_SCHE<wbr />MA].[SCHEM<wbr />ATA]
</div>


a wise expert once said to use master views rather than tables wherever poss:

SELECT [CATALOG_NAME]
FROM [master].[INFORMATION_SCHEMA].[SCHEMATA]

<div>
<div class="content wysiwyg-content">
Visual C# Windows Application.<br />
<br />
Is it possible and if so how do you query the SQL Database Names when you have the Server Name and Instance?<br />
<br />
For instance: &nbsp;I know the server name is SQLSERVER1 &nbsp;and the instance is SQLEXPRESS. &nbsp;How do I get a list of the 3 or 4 databases on that server: master, mydatabase, etc.<br />
<br />
Thanks for the help.
</div>
</div>


Visual C# Windows Application.

Is it possible and if so how do you query the SQL Database Names when you have the Server Name and Instance?

For instance:  I know the server name is SQLSERVER1  and the instance is SQLEXPRESS.  How do I get a list of the 3 or 4 databases on that server: master, mydatabase, etc.

Thanks for the help.

SQL Database Names

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.