Hi,<BR><BR>Following is the piece of code iam executing to capture the stream returned by the command object<BR><BR> Set adoCmd = Server.CreateObject ("ADODB.Command")<BR> Set adoStream = Server.CreateObject ("ADODb.Stream")<BR> <BR> Set adoCmd.ActiveConnection = adoConn<BR> <BR> adoCmd.CommandType = adCmdText<BR> adoCmd.CommandText = "select * from emp for XML auto"<BR> <BR> adoStream.Open<BR> adoCmd.Properties("Output Stream").Value = adoStream<BR> adoCmd.Execute ,,adExecuteStream<BR> <BR> Response.write adoStream.size<BR><BR>The size is always returned as zero and iam not able to retrieve and view this stream.<BR><BR>Let me know if there are any probs with the code.?<BR><BR>