How to build your own SQL Server Explorer

re: How to build your own SQL Server Explorer

Andew Michnik — Thu, 23 Jul 2009 08:46:12 GMT

Fantastic

re: How to build your own SQL Server Explorer

Ambal — Wed, 08 Jul 2009 17:59:20 GMT

Is there any other way to find whether a column of a table is PK or FK? You have used the following code to determine that.

bool isPrimaryKey = row["constarint_name"].ToString().StartsWith("PK");

What if the primary key name doesn't start with 'PK' or 'FK'?

re: How to build your own SQL Server Explorer

waleed — Thu, 28 May 2009 10:25:00 GMT

thanks a lot malovicn

you helped very much in the indexColumns part.

thanks and best regards

Kostenloser WEB Space

Kostenloser WEB Space — Wed, 21 Jan 2009 13:00:57 GMT

Archiv aus Deutschland und aller Welt mit Informationen und Links zum Empfang von Webradio, Web-TV

re: How to build your own SQL Server Explorer

Chikelue Oji — Fri, 14 Nov 2008 11:07:59 GMT

I just figured out that I could test for the list returned by GetDataSource and if it is null when I am not connected to a LAN, then I could prompt the user for a Sql Server instance. This is a manual way of doing this and the user would have to know the instances beforehand.

We can hard code the instances as shown below and the program would still work.

//string[] strLocalServers = new string[] {"chikeo-pc", "chikeo-pc\\sqlexpress"};

//Later add code to check if List servers is null and then to accept entry of server instance name from the user if so.

//If IList<string> servers is null, that means that the host computer is not connected to a local area network.

//IList<string> servers = SqlHelper.GetActiveServers();

int machineNameLength = Environment.MachineName.Length;

int selectedIndex = -1;

Please if anyone has any other way of doing this, please let me know. If it can be done with SQL-DMO, can SQL-DMO be used for enumerating SQL 2005 as well and how can I use it without installing Enterprise Manager?

Thanks indvance.

re: How to build your own SQL Server Explorer

Chikelue Oji — Fri, 14 Nov 2008 09:42:48 GMT

Wonderful article but like Peter identified, it seems it doesn't retrieve any Sql Server instances for standalone machines. How can one get a list of Sql Server instances when the machine is not connected to network but it is having multiple SQL Server Instances running in it?.

Thanks a lot in advance for your reply.

re: How to build your own SQL Server Explorer

David Lean — Sun, 14 Sep 2008 11:21:44 GMT

Excellent Article. Much clearer than other documentation out there. Thanks

re: How to build your own SQL Server Explorer

Peter — Mon, 17 Dec 2007 20:20:51 GMT

It seems that GetDataSource will not work when a machine is not connected to network. How can I get list of SQL Server Instances when the machine is not connected to network but it is having multiple SQL Server Instances running in it?

re: How to build your own SQL Server Explorer

Peter — Mon, 17 Dec 2007 20:19:09 GMT

It seems that GetDataSource will not work when a machine is not connected to network. How can I get a list of SQL Server Instances when the machine is not connected to network and has multiple SQL Server Instances running on it?

re: How to build your own SQL Server Explorer

oykica — Thu, 22 Nov 2007 15:09:49 GMT

Thanks for sharing your code.

I think the formatting for the decimal data type should be:

string.Format("{0}({1},{2})", columnDataType, row["numeric_precision"], row["numeric_scale"]);