I tried the solution, what i had given to u, on my m/c. But unfortunately it didn't worked.
The reason is that, the sysloginroles table has insert permission to sso_role role only.
So it will not allow any user, not having sso_role, to insert in the table. bcp in will also not help.
So you need to try any of the below options.
1. Try to modify the sysprotects table to grant the insert permission on sysloginroles to sa, and then try to insert a row in sysloginroles(which will also not work most probably, as I have every doubt that, sysprotects also have insert permission to sso_role only).
2. If above works, then good, else you are left with only two choices.
a. if u have a backup of master(where sso_role was assigned to some login), load master database with that dump, keeping in mind the database alteration, device creation after the time of master database dump, will be lost and may cause to corruption( so a detailed planning is needed for this)
b. The other way which is easy to implement but is time consuming, is take the dump of all the user database, gather the information of all the devices, take the bcp out of syslogins,sysloginroles,sysdevices,sysdatabases and sysusages. Take the ddlgen of all the databases(create database) or save the o/p of sp_helpdb <user_db> for each user database.
Install a fresh ASE, create the devices, and user databases, load the user databases, from the dumps taken previously. Cautiously bcp in the sysloginroles, taken previously. precaution here is to do the bcp in, in such a manner, so that the system default roles and logins are not get effected, by your bcp in.