?????????и?洢?????

????exec UCreateOrAppendTextFile 'C:Error.log'??'hello majaing'

??????????????′????????Ole Automation Procedures???????

??????????????SQL??

go
sp_configure 'show advanced options'?? 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures'?? 1;
GO
RECONFIGURE;
GO

???????м?????????

??????????????д洢??????????? ??????????

????????????洢??????????????????????￡?

CREATE PROCEDURE LOGError(@msg nvarchar(400))
as
declare @text nvarchar(400)
SELECT  @text=text FROM sys.messages WHERE language_id=1033 AND  message_id=@@ERROR
if len(@text)>1
begin
set @msg=@msg +' : '+@text
 EXEC dbo.UCreateOrAppendTextFile 'C:Error.log'??@msg
end

??????д洢???????????￡?

 

????

????洢??????MSSQL2005??2012?в????????