A big thank you to all.

Very much appreciated.

🙂

they do need to be handled differently. if anyone is interested:

comm.Connection =

this.conn;

comm.CommandText =

"sp_mysproc";

comm.CommandType = CommandType.StoredProcedure;

comm.Parameters.Add(

"@id1", SqlDbType.Int).Value=51

i don't know if this is true or ondicative of another problem.

we had a three tier app that handled hundreds of connections with no problems. ASAIK sql server handles the...

try using SQLCommand and setting the CommandTimout to a higher value 

SqlCommand comm =

new SqlCommand(strQuery, conn);

comm.CommandTimeout =

300;

if you still get the...

check out http://forums.devshed.com/archive/t-166713 contains a somewhat messy solution that would slow down pretty quickly the 'deeper' you wanted to delve.

I agree also, there have been many arguments that i've had with programmers about the design of the database being more important and this article gets it spot on.

i couldn't find any reported bug that matched your situation but did frind this http://go.microsoft.com/fwlink/?LinkId=31049

which may include help - haven't read it yet so don't know but it is...

I totally agree with AKM.

Once Yukon comes along as well the .net framework will be kind of important

have a look at the Identity keyword in BOL for the first part of your question.

i don't understand the second part

I can't understand why you have structured the data in your tables in this way.

Maybe a better approach would be to look at a better design to solve your problem...

I can confirm this is the case. I was on the Ascend Beta program for Yukon at my old place of work and the NDA is pretty tight. They wouldn't...

this should get you going

exec dbo.sp_MSforeachdb @command1="use ?;DBCC SHOWCONTIG"

this seemed ok at a glance ...

http://databases.about.com/library/weekly/aa031101c.htm

google is littered with examples on transactions and power failures

all uncommitted transactions will be rolled back to keep the database in a consistent state

what about select max(sum(quantity)) from  ...