1. In which database table are the service pages accounts stored? is it in rep_accounts?
Can anyone suggest an SQL query that would return the account login names?
Could it be possible to create the sp accounts by directly inserting data to this table using an SQL insert query? if yes is this table linked to other tables that i might need to insert data to it too?
select acc_loginname from rep_accounts where acc_subtype='281481481158664'
As for creating accounts directly, you'd rather use data exchange. But if you really want to do it, you need to insert two records, one in rep_accounts, and another in rep_roles_per_account (to link to the service pages role)
Elias, if you do not want to endanger your SD intsallation I would not try to insert data directly. SD uses some sofisticated mechanism to generate unique OIDs for objects and by adding records manually you may break this (i.e. SD will create object with the same OID for example that would lead to database inconsistency).