Viewing 10 posts - 31 through 40 (of 40 total)
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...
October 26, 2005 at 4:58 am
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...
October 26, 2005 at 2:40 am
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...
October 26, 2005 at 12:27 am
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...
October 25, 2005 at 6:33 am
First of all thanks for humiliating
Ne ways...i asked the first problem just for my knowledge
September 26, 2005 at 5:16 am
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...
August 15, 2005 at 4:14 am
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...
August 15, 2005 at 3:39 am
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...
August 15, 2005 at 2:54 am
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...
July 19, 2005 at 1:23 am
Viewing 10 posts - 31 through 40 (of 40 total)