June 29, 2009 at 10:24 am
First, I run "sp_helplogins" and it returns the usual information. One of the result sets is 16 rows, the second one is 32 rows.
When I go to SSRS, create a new dataset, click 'store procedure' and enter "sp_helplogins" the only fields returned are those of the first set , which include "LoginName, Sid, DefDBName, DefLangName, AUser, ARemote'.
The problem is, I need the fields in SSRS to be that of the second set, which are the 'LoginName, DBName, UserName UserofAlias'. I have tried modifying this a bit to return just these but to no avail.
Anyone have any idea how to get the fields under the new dataset to be that of the second set of information sp_helplogins returns? Or does anyone know an easier way about going to get all the databases and each user and user role on them instead of using sp_helplogins?
Any help is appreciated. Thanks!
June 29, 2009 at 10:27 am
You can only return one recordset with SSRS. You'd be better off writing your own view/proc to accomplish your needs.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply