Clear Transaction logs

You can clear the transaction log by using the following command

Dump tran < db_name > to < file_name >
OR
Dump tran < db_name > with truncate_only
OR
Dump tran < db_name > with no_log

Please read the sybase documents for more details.

Note : Dump tran will not work, if your database option is set
to "truncate log on checkpoint".

if still log is not cleared then, either you can kill the process
or can abort the transaction log by using lct_admin command.

Logging in SQL server

ALTER procedure CreateLog
(
@Msg varchar(500),
@Category varchar(50),
@Type varchar(50),
@FilePath varchar(50) = 'C:\MyLog.txt'
)
as
begin
declare @cmd varchar(2000)

set @cmd = 'echo Category: '+ @Category +', Type: '+ @Type +', Date:' + convert(varchar(30),getdate())+', Message: ' + @Msg + ' >> ' + @FilePath
exec master..xp_cmdshell @cmd
end

COTS packages

COTS packages (vs. a custom build) that offer capabilities around calculating/reporting on the performance of the funds:



Confluence
DST (Hi Performance)
Eagle (Pace)
Factset
Milestone Systems
Statpro
SS&C (Sylvan)
Sungard