MsSQL Database browser

[lishniy]

How can i browse database name and server to connect?

[r035198x]

To query the database for other objects you need to connect to it first. Usually one knows the server name and the database name. So you don't know both? So what information do you currently have about the database? If you have nothing then ask the person that installed the database.

[lishniy]

i know server name(actually it is localhost), but database create user and name can be various.
so i have connection line:

SqlConnection connection = new SqlConnection("Data Source=(local)\\DB_name;Initial Catalog="can_be_various";Integrated Security=True");

I need to browse Initial Catalog of my DB

[r035198x]

Outside .NET you would run the

EXEC sp_databases

sql.
In .NET you can use the SQL Server Managed objects see guide here http://msdn.microsoft.com/en-us/library/ms162169.aspx

Then you can get the server using

server = new Microsoft.SqlServer.Management.Smo.Server("localhost");

and the databases using

server.Databases