SQL connection

This may seem like a silly question but,

I have a website which has an SQL database, (this was already set up when I aquired the site)
My question is how do I connect to the Database in order to modify the structure of it?
I can currently set up a ODBC connection to view and alter the contents but it will not allow me to modify a table's properties. For example add a new column or change a cell property from text to memo.
I have been advised to use Microsoft Enterprise Management software to connect,
Where can I get hold of this software?
and what is the likely cost?
Predicting your answer to that.....is there an inexpensive alternative?
I am running Windows 98 om my machine and the SQL is SQL 2000.

Many thanks
Andyfal

 

 

 

 

Top