That shouldn't raise a flag.

Can you send me your full SQL statement?  I have a pub database and I have a statement like this:

DECLARE @ptrval varbinary(16)
SELECT  @ptrval = TEXTPTR(logo)  FROM WHERE AND p.pub_name = 'New Moon Books'
SELECT @ptrval

and when I run this query against SQL Azure, I get an error message back saying:

Built-in function 'TEXTPTR' is not supported in this version of SQL Server.

Anyway, let me see what you have so I can reproduce it and see what scenarios TEXTPTR actually works.

If you want to get rid of the message you can edit NotSupportedByAzureFile.config and look for the line that has "TEXT(PTR|VALID)" and delete that line.

Thanks,
George

The issue wasn't the [function] TEXTPTR()...

The issue is if you have a local parameter that just happens to be named @textptr . This *is* valid, but it fails on your syntax check.

Ok, I will see if I can't tighten up the script a little.  You should be able to just ignor this warning for now.

Thanks!
George

Ok, I modified the Regex in NotSupportedBySQLAzureFile.config (see SQLAzureMW v3.3).  Check it out and let me know if it still flags textptr.

Regards,
George