Can't modify the UDFs I create

I am logged in using an account that is dbo on this database. I created a new UDF, which works fine (I can execute it). When I right click on it in the object explorer and select modify, it says:

Property AnsiNullStatus not available for UserDefinedFunction '[dbo].[fn_MVParamV]'. This property may not exists for this object or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

I would think that if I had the rights to create, as well as use, the function then I should have rights to modify it. I get a similar error if I "script to new window as ALTER..."



Answer this question

Can't modify the UDFs I create

  • Shaan Rathi

    This sounds like the following bug, which is scheduled to be fixed in Service Pack 1:
    http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=FDBK38845

    Steve Kass
    Drew University

  • Can't modify the UDFs I create