Hi,
I'm getting my feet wet with VB.NET by building a little web app that will let me retrieve records (for browsing purposes) from tables in our various SQL Server databases. What I want to do is dynamically create a list of 'user' tables (not the system tables) in a particular database and populate a drop-down listbox - once I pick a table from the drop-down list it will populate a DataGrid on my webform.
I had a look in the master database and there are 930 stored procedures! Does anyone know if there is a sp in the master database that will return the names of the user tables when passed the database name? In the meantime, I'll try to figure it out myself...
Thanks in advance,
Al
Al Williams
Anola MB, CANADA