sql server management studio download 2000

There is a free and portable (no install) tool called FlySpeed that I've used on occasion, which is ok for querying and navigating databases / objects. Of course you can do everything you need using T-SQL from a query window, but going with any other tool (like MS Access, Query Analyzer 2000, FlySpeed SQL, Oracle SQL Developer, etc.) you're going to miss out on database management related functionality in the GUI. You mentioned that you are managing the database.

I don't mind at all stepping out from the Microsoft stuff - I've encountered huge undocumented issues with backward compatibility over the years (this is the latest of many many occurrences) and I'd be pleased to say goodbye if I can find something else that does the job for editing table properties and queries. I've also seen a product called HeidiSQL and another called EMS SQL Manager Lite for SQL Server and I wonder if anyone has used either of these and could comment on them. One great thing about Query Analyzer was that it was free forever from the trial installation package and it looks like the express version of SQL Server has the same so that sounds great. It's only because I thought I might need to edit a query and checked it (luckily I didn't) that I encountered the issue. I've actually only just found out about the issue as my daily routine involves just running copy queries on the DB and these work fine with both ADP and Query Analyzer. Thanks for the info and glad to hear that I'm not boring everyone with the hundredth post on this!

Sql server management studio download 2000