To test this out, I create a job 'AddUser' which just contained the code sp_addlogin 'test'.

Not sure whether it is possible to use SQL-DMO in Access 97 so I tried using Transact SQL in Query Analyzer:

Use msdb

EXEC sp_start_job @job_name = 'AddUser'

Still a SYSADMIN problem which I overcame by using xp_sqlagent_proxy_account. Managed to set this up using my account so that any user could run the job from Query Analyzer. However it is not possible to incorporate the 'use msdb' line in a procedure.

Is there a way using transact SQL to run this job from a procedures? Also are there any dangers setting up xp_sqlagent_proxy_account with SYSADMIN role.

If I can sort the above out, then processing the intermediary table should be a piece of cake.