If i use SET ROWCOUNT like so ...<BR><BR>sSql = "SET ROWCOUNT 5 SELECT ItemDesc, Sum(NetQty) FROM cmDo2 ..."<BR>Set rs = MyConn.execute(sSql)<BR><BR>How long does that stay in effect? do I need to do a SET ROWCOUNT 0 or something to turn it off? It seems like when I run pages that use the SET ROWCOUNT statement, other pages are being affected by it. Each page creates and destroys it&#039s own Connection object.