>When you do your queries in SSMS, are you using the sp_executesql approach? Also, what platform are you using to access your SQL Server data?
I only use the sp_executesql when I've to execute dynamic SQL and return value(s) to the calling code. I don't remember ever using it from SSMS directly.
--sb--