Is there something that could be used instead of the Query Analyzer that comes with SQL Server 2000?
Printable View
Is there something that could be used instead of the Query Analyzer that comes with SQL Server 2000?
Whats wrong with Query Analyzer? there are others but you need to buy them I think. I write most of my T-SQL in TextPad with syntax highlighting turned on.
Its not that there is something wrong about it. At times I just feel that it lacks some handy features like what we have in the VB IDE.
Will look into that TextPad if it is better to use.
Not must not intellisense either. Red Gate has one and a cpuple of others do also but as I said pay for only. Try the RedGate Toolbelt to see it it could meet what you want.
You can use Management Studio, but if you don't have a later version of SQL Server around you will only be able to get hold of the Express edition (download link in the SQL Server thread at the top of this forum).
I do have SQL Server 2005 Express and its Management Studio but I happen to be more at home with using the Query Analyzer if it involves SQL Server 2000 databases. I think both are not robust enough.
I've started using Management Studio 2008 recently - it's more like the VB IDE in regard to things like "respecting" the current tab position as you click enter - things like that.
They got rid of the "highlight" the open/close parenthesis for some reason - I like that in 2005.
I was forced into the upgrade to SSMS 2008 because my laptop's video driver would no longer work with SSMS 2005 - and I was forced back to MS 2000/QUERY ANALYZER and that step back was too far...
As SSMS 2005 can add a registration for SQL Server 2000 is it still the same with SSMS 2008?
I cannot answer that unfortunately - I can't think of anywhere that I've got a SQL 2000 install still...
Maybe an old laptop in my office - if I remember on Monday I'll check...