Whats the deal with CFMX and MSSQL Server? As soon as you want to do anything trick with a query, the server seems to hold on to previous information
example SET ROW COUNT 20 SELECT * FROM Table After a query like this, any query you perform on that database will only return 20 rows Then you get into querying other databases from a different database and everything goes haywire Is there any way to break the connections to the databases to stop this happening? Steve --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
