I found a way....its the KILL statement.....KILL statement requires the SPID of the process to be killed, i wrote the following code to find the SPID's of my Database, but...

yah thats wat i was thinking but u know i dont need to use the COL_LENTH function coz all my columns (except TimeStamp) will be DECIMAL(38,6) therefore each column will...

ooooo guys where r u goin...

the solution provided by Kory Becker was perfect, but after that i asked about the limit on the row width...

Thanks alot, indeed an implementable idea, but in this case i want to know that how will i check that the row size of the table has reached to its...

First of all thanks for humiliating

Ne ways...i asked the first problem just for my knowledge

thanks alot the problem is solved

Thanks alot...i think the problem is near to be solved after the resolution of the following error

Actually in my case the data type...

Ok Fine....Actually your solution works for select statement of one table but if i use a UNION operator then the following error occors

"ORDER BY items must appear in the select list if...

Sorry my fault actually the query was.

SELECT Col1 FROM Table1

ORDER BY Col1 ASC

and the result is

NULL

NULL

1

2

3

4

5

Now I use your solution (Using 2147483647) But the error occors that the...

Thanks for the reply,

But the problem is why should i set the timeout option in ODBC as i am running the query in Query Analyzer or even in Enterprise Manger.

And...