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/d...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/d...8-82c8-479c-b2
> 5b-9aca13141c9e&displaylang=en
>
> HTH,
>
> 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!

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> escreveu na
mensagem news:C4A29065.C428%ten.xoc@dnartreb.noraa...
> 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
>

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

"Paulo" <eris_paulo@terra.com.br> wrote in message
news:udthJo05IHA.2348@TK2MSFTNGP06.phx.gbl...
> And about any free sql management for MSSQL 2000? Because I only know
> DataBase WorkBench and it is expensive!
>
> Thanks!
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> escreveu na
> mensagem news:C4A29065.C428%ten.xoc@dnartreb.noraa...
>> 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
>>
>
>

The SSMSE does not have the Ctrl+Space (intelisense) showing the
tables/fields of a database!

"Russell Fields" <russellfields@nomail.com> escreveu na mensagem
news:eBUD0y05IHA.3512@TK2MSFTNGP02.phx.gbl...
> 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
>
> "Paulo" <eris_paulo@terra.com.br> wrote in message
> news:udthJo05IHA.2348@TK2MSFTNGP06.phx.gbl...
>> And about any free sql management for MSSQL 2000? Because I only know
>> DataBase WorkBench and it is expensive!
>>
>> Thanks!
>>
>> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> escreveu na
>> mensagem news:C4A29065.C428%ten.xoc@dnartreb.noraa...
>>> 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
>>>
>>
>>
>
>

Paulo,

Sorry, I did not read far enough back up the thread. You are right: no
Intellisense.

RLF

"Paulo" <eris_paulo@terra.com.br> wrote in message
news:OWs3o105IHA.5024@TK2MSFTNGP06.phx.gbl...
> The SSMSE does not have the Ctrl+Space (intelisense) showing the
> tables/fields of a database!
>
> "Russell Fields" <russellfields@nomail.com> escreveu na mensagem
> news:eBUD0y05IHA.3512@TK2MSFTNGP02.phx.gbl...
>> 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
>>
>> "Paulo" <eris_paulo@terra.com.br> wrote in message
>> news:udthJo05IHA.2348@TK2MSFTNGP06.phx.gbl...
>>> And about any free sql management for MSSQL 2000? Because I only know
>>> DataBase WorkBench and it is expensive!
>>>
>>> Thanks!
>>>
>>> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> escreveu na
>>> mensagem news:C4A29065.C428%ten.xoc@dnartreb.noraa...
>>>> 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
>>>>
>>>
>>>
>>
>>
>
>

> 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.

--
Ekrem Önsoy



"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:edG3fL15IHA.616@TK2MSFTNGP02.phx.gbl...
>> 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 ed
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.
>
> 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.

Aaron Bertrand [SQL Server MVP] wrote:
> 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 ed
> 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.
>>
>> 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.
>

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