locked
Error when creating Tracking-Database in SQL Azure RRS feed

  • Question

  • I would like to store my SQL Tracking database in SQL Azure, but since Azure SQL does not support the "OPENXML"-syntax, I cannot create the stored procedures InsertActivities or GetWorkflows. (taken from file Tracking_Logic.sql)

    This is an example of the code that is causing the error:

    DECLARE activities INSENSITIVE CURSOR FOR
    SELECT [TypeFullName]
    ,[AssemblyFullName]
    ,[QualifiedName]
    ,[ParentQualifiedName]
    FROM OPENXML ( @hdoc, '/Activities/Activity',2) WITH
               (
    [TypeFullName] nvarchar(128)
    ,[AssemblyFullName] nvarchar(256)
    ,[QualifiedName] nvarchar(128)
    ,[ParentQualifiedName] nvarchar(128)
    )

    OPEN activities
    FETCH NEXT FROM activities INTO @FullName, @Assembly, @QId, @PQId

    Is it possible to replace "OPENXML" with something else that is supported by Azure SQL?

    Thursday, December 6, 2012 10:03 AM