Can you send me your full SQL statement? I have a pub database and I have a statement like this:
SELECT @ptrval =
WHERE AND p.pub_name
= 'New Moon Books'
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