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