Try SQLGetInfo(SQL_MAX_COLUMNS_IN_INDEX). ...cmk Save the whales - collect the whole set

Have you installed service pack 1 for SQL Server 2005. This seems to make the front end stable. Look where you want to go not where you don't want to crash. Bikers Bible

Kuira, You can run both side by side. Paul

to do the SqlCommand.Cancel you probably would put that on ThreadAbortException............

Well, in theory anyway, your query worked. What you got back in the ExecuteScalar method is a dataset with two result sets. The first being a 1 row, 1 column table that returned the number of rows affected, 1. The second set, which ExecuteScalar always ignores, contained a 1 row, 1 column table with the value 0 in it. This is the actuall restult of your query. To fix this, make sure you include "SET NOCOUNT ON" in your SQL batch: string mySqlStatement = @"SET NOCOUNT ON;SELECT COUNT(column) FROM table WHERE condition;SET NOCOUNT OFF"; If your executing a stored procedure to return the code, put the NOCOUNT statements in the procedure, not your code. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome -- modified at 0:33 Thursday 5th January, 2006

There you go: //"this" refers to the current form object Point somePoint = this.PointToScreen(Location); //Note it calculates it from upper-left edge of the client area, not the border. I don't think there is a specific function to do that, but you can easily calculate it if you want the location of the form from the border. This is the width and height of the border in pixels: {X=3,Y=29}. Of course if you have tool border (smaller) it will be different. If you want to check that set the form start position to manual like so: this.StartPosition = System.Windows.Forms.FormStartPosition.Manual; This will make your form/dialog box open in the upper-left edge of your screen. ______________________________ |_____________________________|<- form/dialog box border ||...........................................|| ||...........................................||<- form border ||.......................<-------------||--- client area ||...........................................|| ||...........................................|| ||___________________________|| -- Don't worry about the world coming to an end today. It's already tomorrow in Australia -- -- modified at 22:34 Tuesday 27th December, 2005

Kuira wrote: Is there a way such that I can use the Process to store it as a string without resorting to using a shell to execute the command, store it as a text file, read its contents then removing the temporary text file? Yes. Basically you need how to learn to redirect the standard output. The following article and code will do exactly what you want and more: Run other programs from your .NET code[^] Hope it helps.[ My articles and software tools ](http://mysite.verizon.net/XiangYangL/index.htm)

Ok sounds like a good plan to me, I'll use that thanks.

I figured it out why it was slow, it was due to SQL Transactions.... Now gotta work out how to speed it up...... Basically what I did that slowed it down was an INSERT SELECT TO Statement, and no I didnt use stored procedures since I also tried that with the same outcome. Basically in PSEUDO form was more of a INSERT INTO table1 SELECT [blah blah blah] FROM #a INNER JOIN #b ON 1 = 1 INNER JOIN table2 ON a.[field] = table2.[field] AND [etc]. WHERE something = something