> I want to update some records with CLR-Function. But I got error that
> indicate I can't edit records with CLR-Function.
>
> "Error Message: A .NET Framework error occurred during execution of
> user defined routine or aggregate fn_myFunction:
> System.Data.SqlClient.SqlException: Invalid use of side -effecting or
> time -dependent operator in ‘UPDATE’ within a function."
>
> As a alternative way I create T-SQL function which update my records
> and call this function in that CLR-UDF. But ther error stills.
> Some one told me use IsMutrator parameters, but I think this is for
> UDT only.

"Ole Kristian Bangås" wrote:

> =?Utf-8?B?Sy5r?= <K.k@discussions.microsoft.com> wrote in
> news:5E04FAE4-CFCC-4437-A46F-86C6E670F704@microsoft.com:
>
> > I want to update some records with CLR-Function. But I got error that
> > indicate I can't edit records with CLR-Function.
> >
> > "Error Message: A .NET Framework error occurred during execution of
> > user defined routine or aggregate fn_myFunction:
> > System.Data.SqlClient.SqlException: Invalid use of side -effecting or
> > time -dependent operator in ‘UPDATE’ within a function."
> >
> > As a alternative way I create T-SQL function which update my records
> > and call this function in that CLR-UDF. But ther error stills.
> > Some one told me use IsMutrator parameters, but I think this is for
> > UDT only.
>
> This is by design: "User-defined functions cannot be used to perform
> actions that modify the database state.". In other words (as I read this)
> DML and similar methods in .NET is not allowed within a function, you
> should use a stored procedure instead. Yeah, I know. This is really
> frustrating.
>
> --
> Ole Kristian Bangås
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging