We have a server with full text searching enabled and another where it is not. We have a stored proc that checks if full text indexing is enabled and runs a search query as appropriate but the issue ...

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...

Yes a sproc can return multiple resultsets and you can even work with them in ADO, though it is somewhat esoteric.