>Don't think that's true - it *is* true for each connection so you should be able to do something like:

>.CommandText = "RAND(-1)"
>.ExecuteNonQuery()
>.CommandText = "SELECT TOP 10 RAND()....."
>.Fill(...)

I send this command ok but the result of the SQL remains the same. Basically, I am extracting five records that should be random. For the five records, everytime I run the SQL, I get a random value but it is the same for all records.