parse again

28 Jul 2006 2:15 PM

Roger

Hi MICROSOFT

Platform: Windows 2003 R2 64 bit 32 GB RAM
Sql Server 2005 Enterprise 64 bit with SP1 and all fixes
applied

Executing Parse in Sql Server 2005 Management Studio I get the following
error:

".Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded."

Can you help-me ?
Thanks in advance

28 Jul 2006 2:29 PM

Aaron Bertrand [SQL Server MVP]

Could you help us help you? What is the query you are trying to parse? How
about DDL for the object(s) involved in the query?

Show quote

"Roger" <roger@rnospam.com> wrote in message
news:e4ilLAlsGHA.3952@TK2MSFTNGP03.phx.gbl...
> Hi MICROSOFT
>
> Platform: Windows 2003 R2 64 bit 32 GB RAM
> Sql Server 2005 Enterprise 64 bit with SP1 and all fixes
> applied
>
>
> Executing Parse in Sql Server 2005 Management Studio I get the following
> error:
>
> ".Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0
> A severe error occurred on the current command. The results, if any,
> should
> be discarded."
>
> Can you help-me ?
> Thanks in advance
>
>
>

28 Jul 2006 7:48 PM

Roger

Hi,

I type SELECT * FROM ... (yeah, any table) and the PARSE don't work.
Nothing works with PARSE. I always receive the error message.

Thank you.

Rogério

Show quote

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> escreveu na
mensagem news:uGou4IlsGHA.4324@TK2MSFTNGP05.phx.gbl...
> Could you help us help you? What is the query you are trying to parse?
> How about DDL for the object(s) involved in the query?
>
>
> "Roger" <roger@rnospam.com> wrote in message
> news:e4ilLAlsGHA.3952@TK2MSFTNGP03.phx.gbl...
>> Hi MICROSOFT
>>
>> Platform: Windows 2003 R2 64 bit 32 GB RAM
>> Sql Server 2005 Enterprise 64 bit with SP1 and all fixes
>> applied
>>
>>
>> Executing Parse in Sql Server 2005 Management Studio I get the following
>> error:
>>
>> ".Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0
>> A severe error occurred on the current command. The results, if any,
>> should
>> be discarded."
>>
>> Can you help-me ?
>> Thanks in advance
>>
>>
>>
>
>

29 Jul 2006 11:06 AM

Erland Sommarskog

Roger (roger@rnospam.com) writes:

> I type SELECT * FROM ... (yeah, any table) and the PARSE don't work.
> Nothing works with PARSE. I always receive the error message.

Open a command-line window. Connect with SQLCMD and issue

SET PARSEONLY ON
go
SELECT * FROM anytable
go

What happens?

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx