I have a stored procedure that I need to change the # of resultsets to 1 (it is currently 2). I have tried to change it (under Catalog Explorer, right click the sp and select Set Number of ResultSets and set it to 1), but the number does not change?

that's the case if you already imported the resultsets. Uncheck the proc when retrieving resultset data on the last tab where you can specify which procs to pull the resultset info for.

Btw, if a proc has 2 resultsets and you specify '1', the first one is obtained, but that's fragile. Refactor the proc to only have 1 resultset, or refactor your code to deal with both resultsets in memory. You can also map a typed view on the resultset you want, and ignore the other one.