I am trying to write a sproc which will create a server login and
database user id when a record is inserted into a user table called
user_profile. But I get and error message saying that "sp_addlogin
cannot be run within a transaction". Is there a workaround for this?
Basically, the adding of new users is being forced from a front end
application. The server is Sybase ASE 11.5./ Application is PB5.