Microsoft® SQL Server™ 2000 stored procedures return data in four ways:

A result set for each SELECT statement contained in the stored procedure or any other stored procedures called by...

Thanks Steve. That's about as it easy as it gets.

Love this site.

Windows Auth is not an option for the internet/application server prov model. We will never use IIS and therefore not use it's inbuilt accounts. Thanks for the article!