Managing SQL 2000 databases on Vista...

I have one database at an ISP running on a SQL 2000 server. Under Windows XP Pro, I installed SQL 2000 administrative tools then I could use the database manager as well as the query tool to manage my database.

I have upgraded my machine to Windows Vista Ultimate. SQL 2000 client services won't install under Windows Vista.

Under Windows Vista, I was able to create an ODBC component that connected successfully to the SQL 2000 remote database, but I no longer have a transaction tool or a gui to manage the tables.

My goals are simple: I want to be able to view/add/drop tables and data using some sort of GUI. I would also like to have some sort of SQL transaction client. I don't need to do any high level database management, just view/change/add/delete tables in the one database that I own on that server.

My isp is NOT going to upgrade their SQL. I do not own Microsoft Access or Microsoft Excel. What FREE software options do I have, given my goals?

You can use SQL Server Management Studio Express, which you can obtain for free at http://msdn.microsoft.com/vstudio/express/sql/download/

Thanks,

Peter Saddow

|||That works absolutely perfectly. Thank you!
|||Although now I have another question since I've played with it a bit.

Is there an easy way to import and export data from tables using this tool? Like... if the data was in a comma delimited text file, for example? So far I've not been able to find a way to do this... I can edit the table data which is good but what if i have a massive text file I want to import....?
|||

You can use the bcp utility: http://msdn2.microsoft.com/en-us/library/ms162802.aspx

Additional, you can download the eval version of the full SQL Server product.

Thanks,

Peter Saddow

|||The BCP utility is part of the database install disk for SQL server. I only have the 2000 version, not the 2005 version.

Downloading Eval version isnt' a permanent solution...

I did purchase MS Office Excel 2007... and I can create an ODBC link to the database and grab table data... but if I edit the table I can't seem to find a way to get it to save those changes back to the table directly?
|||Hmm anybody? No response yet....