DB with 700 tables and no documentation or source code help

Hi, I am new at my company, and want to figure out which table has what. I have no code or docs from the previous programmers work and must figure it out myself.

Using "Add New Data Source" I can connect to the MS SQL 2000 server and see the ~700 tables. I can add a table, drag it to the form, compile and see the cells in a datagridview. I have gotten a user to save some data, and now I want to look for it, and know where it is.

How can I automate going through the tables and looking for the data that the user saved for me? Here is the code I get in my form when I do the above, and get one of the tables:

    Private Sub BsoRelMasterBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BsoRelMasterBindingNavigatorSaveItem.Click
    End Sub

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'CompanyADataSet.BsoRelMaster' table. You can move, or remove it, as needed.
    End Sub
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joel CoehoornDirector of Information TechnologyCommented:
My condolences.  If you don't already have it, you'll want to download SQL Server Management Studio from Microsoft's web site.  Use that to connect to the database and browse the tables a little easier.  

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PizpotAuthor Commented:
I am going there now, and that might satisfy me, but I know I'll need code for such operations soon enough.
PizpotAuthor Commented:
It looks like SQL Server Management Studio is for SQL Server 2005, but we are on 2000. Is there an edition for that, or anyone know the code I need? Would the solution be to connect to the tables one at a time and then loop through the rows and cols to look for a string? That is what I think I want here. :-) Having that code will allow me to do quite a lot of things...
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

Joel CoehoornDirector of Information TechnologyCommented:
SQL Server management studio will connect to 2000 just fine.  You need to download that because you can't just get the old enterprise manager any more.  There are also a number of third-party tools you can use if you want to try googling around for them.
Joel CoehoornDirector of Information TechnologyCommented:
Oh, when you get it installed and connected, you should know that a lot of the functionality of this program is provided by context menus you get when right-clicking on the various items in the tree on the left side.
PizpotAuthor Commented:
is the express version to get?
PizpotAuthor Commented:
oh what the heck, accepted. I am in a good mood and it is working. I'll ask again for code later. Thanks eh.
Joel CoehoornDirector of Information TechnologyCommented:
Sorry, had to step away for a bit- yes, express will be fine for now.  You can't do some things with, like import new data, but for now you just want to explore.
PizpotAuthor Commented:

I wish it would let me find the text I am looking for but it says no file to look in. Do I need to sql query? how do you do that when you don't know the column name you are looking for?
Joel CoehoornDirector of Information TechnologyCommented:
Once you've established a connection, you can browse with the object explorer.  Make sure it's visible by choosing View->Object Explorer from the menu.  Then you can use the tree to pull down tables in your database, and columns within tables.  Right-click to see available operations.
PizpotAuthor Commented:
Oh I see the tables alright, just not anyway to find a data string. :-( Opening and viewing each table is not what I want.
Joel CoehoornDirector of Information TechnologyCommented:
You should be able to see column names and datatypes in the object explorer.  To see actual data in the table right click on a table and choose "Open Table", or choose "New Query" from the toolbar, make sure the correct database is selected, and use "SELECT * FROM <TableName>" for your query.
PizpotAuthor Commented:
Thanks, you've now earned your keep for sure.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.