Post reply

Msg 2812, Level 16, State 62, Line 2 Could not find stored procedure 'xml_schema_namespace'.

  • September 14, 2013 at 3:03 am

    #1650217

    Maybe you could explain in the first place why you expect there to be a function with that name? What does this query return:

    SELECT name, type, schema_id FROM sys.all_objects where name = 'xml_schema_namespace'

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • September 15, 2013 at 2:40 am

    #1650263

    SELECT name, type, schema_id FROM sys.all_objects where name = 'xml_schema_namespace'

    return me an empty set.

    from http://technet.microsoft.com/en-us/library/ms190316.aspx

    This function returns an xml data type instance.

  • September 15, 2013 at 3:08 am

    #1650264

    So this is a built-in system function, not a user-defined function. You cannot invoke built-in functions through EXEC. This is only possible with scalar user-defined functions.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply