@textptr <> textptr()

Mar 1, 2010 at 12:18 AM

That shouldn't raise a flag.

Coordinator
Mar 1, 2010 at 2:19 PM

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

Jun 2, 2010 at 12:48 AM

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.

Coordinator
Jun 2, 2010 at 8:13 PM

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

Coordinator
Jun 5, 2010 at 11:25 PM

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