 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008Free SQL GUI
Hi, do you know any free SQL Server query management (query analyzer) that have code-complete, shows the tables, fields, etc... Version 2000 or 2005 ! Thank you very much! You can use SQL Server Management Studio Express for SQL Server 2005: http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-b25b -9aca13141c9e&displaylang=en HTH, Plamen Ratchev http://www.SQLStudio.com Note that the 2005 version does not have IntelliSense ("code-complete" as the OP called it). The 2008 version of SSMS will (have yet to see an Express edition of the client tools), but only when working against SQL 2008 instances. On 7/15/08 4:31 PM, in article E270E390-3458-47D5-B993-378322EAB141@microsoft.com, "Plamen Ratchev" <Plamen@SQLStudio.com> wrote: > You can use SQL Server Management Studio Express for SQL Server 2005: > http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-b2 [quoted text clipped - 4 lines] > Plamen Ratchev > http://www.SQLStudio.com Yes, I know, but until SQL Server 2008 is released we can only wait... Plamen Ratchev http://www.SQLStudio.com Yep, not correcting you, just setting expectations. I didn't want the OP to go download SSMSE and then come back and yell at you because code-complete was not there. A On 7/15/08 5:27 PM, in article C2594EAA-68A1-4982-8FEA-C1EF9F1914DC@microsoft.com, "Plamen Ratchev" <Plamen@SQLStudio.com> wrote: > Yes, I know, but until SQL Server 2008 is released we can only wait... > > Plamen Ratchev > http://www.SQLStudio.com And about any free sql management for MSSQL 2000? Because I only know DataBase WorkBench and it is expensive! Thanks! > Yep, not correcting you, just setting expectations. I didn't want the OP > to [quoted text clipped - 11 lines] >> Plamen Ratchev >> http://www.SQLStudio.com Paulo, SQL Server Management Studio Express (SSMSE) should be able to manage SQL Server 2000. Although I do not use the Express version of the tools, the full version certainly manages SQL Server 2000 servers and I would expect Express to do likewise. RLF > And about any free sql management for MSSQL 2000? Because I only know > DataBase WorkBench and it is expensive! [quoted text clipped - 17 lines] >>> Plamen Ratchev >>> http://www.SQLStudio.com The SSMSE does not have the Ctrl+Space (intelisense) showing the tables/fields of a database! > Paulo, > [quoted text clipped - 26 lines] >>>> Plamen Ratchev >>>> http://www.SQLStudio.com Paulo, Sorry, I did not read far enough back up the thread. You are right: no Intellisense. RLF > The SSMSE does not have the Ctrl+Space (intelisense) showing the > tables/fields of a database! [quoted text clipped - 29 lines] >>>>> Plamen Ratchev >>>>> http://www.SQLStudio.com > The SSMSE does not have the Ctrl+Space (intelisense) showing the > tables/fields of a database! That is correct. As I explained earlier, you will have to wait for the 2008 version for that, and even then it will only be functional when you are working in a query window targeted at a 2008 server. However that's subject to change. You must be know about this feedback. In a feedback I saw that IntelliSense used to work in earlier CTPs (that I did not check this then...) and this feature is removed somehow in the last releases and an MS guy responded in that feedback that they may add this feature again if people votes enough. I can't remember exactly where I saw this one, sorry.  SignatureEkrem Önsoy >> The SSMSE does not have the Ctrl+Space (intelisense) showing the >> tables/fields of a database! > > That is correct. As I explained earlier, you will have to wait for the > 2008 version for that, and even then it will only be functional when you > are working in a query window targeted at a 2008 server. connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=341872 As you can read Eric's latest comment, it is not subject to change, at least for the RTM release... in spite of all of the votes that I and others helped encourage, the business decision was to support 2008 only. After 2008 is out, it becomes less and less attractive over time for them to add the support back, both because it does not exactly motivate people to upgrade the servers they manage, and because there is still a lot of core work to do (e.g. add support for other DML operations, such as INSERT, UPDATE, DELETE, MERGE etc). I am not entirely happy about this, but these are the trade-offs they face... A On 7/16/08 1:21 PM, in article BD865E85-B7A6-4E8A-945C-E53C41E4D107@microsoft.com, "Ekrem Önsoy" <ekrem@compecta.com> wrote: > However that's subject to change. You must be know about this feedback. > [quoted text clipped - 3 lines] > feature again if people votes enough. I can't remember exactly where I saw > this one, sorry. > connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=341872 > [quoted text clipped - 21 lines] >> feature again if people votes enough. I can't remember exactly where I saw >> this one, sorry. And, there are plenty of tools available that will do this. SQL Prompt from Red-Gate is one of the better ones, as well as SQLAssist. If you want one that will work with multiple databases (Oracle, SQL Server, etc...) I would recommend SQL Assistant. SQLAssist is less than $50 (last time I checked) SQL Assistant is ~$150 SQL Prompt is a lot more ;) Jeff |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.