DB analysis - Strange "not supported in Azure"

Jul 23 at 1:40 PM
Hi There,

I'm analyzing some DBs to plan the migration on Azure. I got some errors like OPENXML, SELECT INTO and it's file.. I can fix them..

Bu I'm getting also something strange like this:
_StoredProcedure [dbo].[usp_select_ProjectModificationOverviewFilters] -- GrantCycleID INT
    ,@Culture NVARCHAR(2) = ''en''
    ,@RoleType INT
    ,@ViewID INT
AS
BEGIN
    -- Get GrantCycles
    EXEC Usp_select_admin_grantcycles @FundId = @FundId
        ,@RoleType = @RoleType

    --Gets Years of  Requests Submitted 
    SELECT DISTINCT Year(submitteddate) AS ProjectYear
    FROM untfprojectmodificationrequest WITH (NOLOCK)
    WHERE isdeleted = 0

    --GET REGION/Countries       
    EXEC Usp_select_territories @Culture = @Culture
        ,@FundId = @FundId

    --Get Metadata List(Organization Type is not supported in current version of SQL Azure_
This is part of my Store procedure... but I cannot understand what is not supported... Can you please help?

Thanks!

F
Coordinator
Jul 23 at 1:49 PM
Hi,

I am curious if you would mind sending me the TSQL generated by SQLAzureMW? I can take a look at it and see. We can take this discussion offline. Just contact me via CodePlex and we can get this figured out.

Thanks,
George
Coordinator
Jul 24 at 8:24 PM
Hi,

I just wanted to check back with you and see how things were going. If you still need help, just contact me via codeplex and I will be happy to work with you to figure out what is going on.

Regards,
George