Im trying to write an application that is able to retrieve the showplan output for an arbitrary query. I make three seperate ADO calls, one to set showplan on, one to run the query, and then supposedly a third to turn showplan off again. I am under the assumption the scope of showplan setting is at the connection level? When I execute the 2nd ADO call, it does not return. I am not sure if this is a sudden server problem Im having (I have another recent post where USE pubs was hanging), or if I am trying to do something that ADO is not capable of. Im using an ADOQuery for all three statements, the first and last being ExecSQL method, and the 2nd (the actual query to profile) is using a simple Open method. Can anyone please advise how I can do this. Or just as good would be how I can get showplan output for a dynamic bit of SQL. Thanks!