Thread: datareader return zero rows, but query in mssql studio returns one

hi all

as the title of the thread says i have a weird problem. when i execute sqlcommand.executereader, the resulting datareader has no rows.

however if i copy the text in the command text and execute it in my sql server management studio (word for word) it returns one row. is there a setting that i am missing? perhaps a security issue?

i am connecting using trusted connection = yes in my code, and integrated windows security with the sql management studio. thus theoretically the security settings should be exactly the same.

any help would be appreciated.
thanks.

edit: im using vs .net 2005 and sql management studio 2005.