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

Use the SQL command... update.


UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]



Have a great day :)

Regards
Amar

I think Enterprise Manager costs - as it is a part of SQL Server 2000 and I don't think you can get just the manager part for free.

My tip:
use a free db manager script
http://www.hotscripts.com/ASP/Scripts_and_Components/Database_Tools/

I am not sure if there is a script allowing easy structure modifications but otherwise just use statements like

ALTER TABLE yourtable ADD newcolumn int null

I'm sorry I made a mistake.
Alter table is the correct one.
Update is to update the contents....

My mistake...

Thanx ASPCode.net

Regards
amar

Thanks for the help people

I'll try out the Hotscripts site..

You should use Microsoft Enterprise manager. You can get it free by downloading the trial version of SQL 2000 at http://www.microsoft.com/sql/evaluation/trial/2000/default.asp. When you install it, just select client tools only. This will give you EM (an no, it will not stop working in 120 days :))

Hope that helps!

Thanks Mike,

This sounds like what I am after.
Now in the process of downloading it, am I correct in assuming it will not work on Windows 98, but needs Win 2000?

Originally posted by RackMy.com
You can get it free by downloading the trial version of SQL 2000 at http://www.microsoft.com/sql/evaluation/trial/2000/default.asp. When you install it, just select client tools only. This will give you EM (an no, it will not stop working in 120 days :))

Although it might be correct that it wont stop working - is it legal to do it with regards to licenses?

Although it might be correct that it wont stop working - is it legal to do it with regards to licenses?Yes, It's legal :)

Cool! I trust you on Windows stuff, RackMy.com so this is really nice to know. It's a great thing to recommend to customers.