Discovering the database structure in code

[CosmicCharlie]

I would like to write some VB.Net code that can discover and return information about SQL Server databases on the network. The goal is to iterate through user tables and their columns, stored procedures and their parameters, etc. What code will do this? Does it require reflection? Will a non-reflection method work?

Also, can this be done at design time, so that, for example, table columns will appear in the intellisense window as I write my code?

I appreciate any insights.

Cosmic Charlie

 

[onpnt]

This is a very easy task. Just execute your SQL like any other transaction but return the information you want by querying the table schema

Here are some helpful links

http://msdn2.microsoft.com/en-us/library/ms186778.aspx

http://www.sqlteam.com/item.asp?ItemID=261

http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_sp.asp

General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[ThatRickGuy]

Take a look a the SQLDMO library from Microsoft.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[CosmicCharlie]

Thanks to you both. This is precisely what I needed. I think using SQLDMO especially will fit the bill perfectly. I am getting on this today!

Cosmic Charlie