Error message - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

Site Related Discussions

Error message

Author

Topic

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-06 : 06:14:09

Is this a message you get a lot? Last two weeks I get this a lot when answering a post.
Some topics work ok, but a few is completely locked for me. Can't post at all. Trying to answer another topic works ok, and trying to resubmit the "faulty" topic gets the error again.

Network Error (tcp_error)

A communication error occurred: ""
The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.

For assistance, contact your network support team.

Peter Larsson
Helsingborg, Sweden

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-06 : 06:18:04

it has something to do with this text. Can't answer any topic with this text below!
When formatting the text, it works ok. When sending only the text, i get the error message above.

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc)

Peter Larsson
Helsingborg, Sweden

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-07-06 : 07:30:48

Test

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc)

Madhivanan

Failing to plan is Planning to fail

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-07-06 : 07:33:42

Both of you missing table alias for derived column!

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc) t

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-07-06 : 07:39:04

quote:
Originally posted by harsh_athalye

Both of you missing table alias for derived column!

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc) t

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

I looked at the text and not the query

Madhivanan

Failing to plan is Planning to fail

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-06 : 07:49:45

You mean SQLTeam has a SQL syntax parser too?

I still can't post the code in red only

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc)

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-07-06 : 07:57:57

Testing...

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc)

Or Maybe Peso, you are not allowed to post such a simple queries after all (taking into consideration all the complex solutions you posted till now)

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-06 : 07:59:06

I still can't post the query only. No text before and after. Not only a linebreak...
The query only in one line without leading and trailing spaces.

Peter Larsson
Helsingborg, Sweden

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-07-06 : 08:08:56

That's very strange. I've never seen that and the site hasn't logged the error. It's got to be something in the network between you and the server. Has anyone else had the problem?

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-06 : 08:22:41

If i put text before the query, i can post... like this!

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc)

putting the query first and text below, also error out.
this is not only on my workstation (company network and internet connection).
it happens on my laptop too (wireless broadband network).

Peter Larsson
Helsingborg, Sweden

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-07-06 : 08:29:33

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc)

Hmmm.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-07-06 : 08:30:15

Can you email me a screen capture?

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-06 : 08:51:35

can it be..... an sql injection bug on sqlTeam? CAN IT???? OH THE HORRRRRRROOOOOORRRRR!!!!!!!!

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-07-06 : 09:07:39

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc)

Test!

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-06 : 09:12:22

Select min(col1) as secondhighest from (select top 2 col1 from table1 order by col1 desc)

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-06 : 09:12:33

works for me...

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources