
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
Hello, Quick, and possibly strange, question. I am doing some work testing the running time of some dynamic SQL statements on a remote machine. What I would like to do is execute the SQL on the remote machine, without returning the result set to the calling machine (this would skew the results, as my connection to the remote machine is rather slow). I believe SET ROWCOUNT 0 would work in principle, but the documentation says: "Causes Microsoft® SQL Server™ to stop processing the query after the specified number of rows are returned." I don't want processing to stop until all the records have been identified. I also don't know if "SET ROWCOUNT" works with openquery (althought a non-openquery solution would also be acceptable). The code will be running in a stored procedure, if that matters. Any input would be much appreciated. Phil
| <-- __Chronological__ --> | <-- __Thread__ --> |