sp_helprole displays no columns (1 Viewer)

[ozinm]

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)



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