View Full Version : sp_helprole displays no columns


ozinm
12-21-2005, 05:20 AM
Am I being rather stupid or is something not quite right?

I'm executing the following stored procedure:
ALTER PROCEDURE dbo.StoredProcedure1
as
exec sp_helprole

and getting back 10 rows but no columns (see screenshot)

11991

Q1. where am I going wrong

Q2. as a side issue if I wanted to use the expected results (ie role ID and Role Name) in a combo box in a form how would I go about it?


Thanks in advance for any help

BTW I'm using MS SQL 2k SP4 & MS Access 2k3 SP1