problem with update using scalar function

i h开发者_运维问答ave created a function:

CREATE FUNCTION FindDistrictId (@param XML)
RETURNS INT
(...)

which i want to use in a stored procedure like that:

CREATE PROCEDURE UpdateDistinctID
AS  
    UPDATE Notices SET DistinctId = FindDistrictId(Notices.XmlContent)
    WHERE DistinctId = 0

I get 'FIndDistrictId is not a recognized built-in function name' when i try to do that. I thought that maybe i can't do Set field = function() but then i checked here and i think it should work.. any idea why it's not? The function is created for sure im my db, i checked sys.object

You need to include the schema (owner if this is SQL 2000 or earlier) of the function on the call. By default, that would be dbo.

UPDATE Notices SET DistinctId = dbo.FindDistrictId(Notices.XmlContent)
WHERE DistinctId = 0