What are the challenges you face when working across database platforms? Take the survey

Find invalid objects: false positive on $PARTITION statement

weswinklerweswinkler Posts: 54 New member
edited August 6, 2012 8:59AM in SQL Prompt Previous Versions
SQL Prompt's "Find invalid objects" feature incorrectly flags the use of $PARTITION function/statement as invalid. (SQL Prompt

Repro: embed any valid statement calling the $PARTITION statement in a sproc. Ask SQL Prompt to find invalid objects in the database.

My example:
select @PARTITION=$PARTITION.pfValidPartitionFunction(@InputData)

In my case, @PARTITION and @InputData are valid local variables in the sproc. pfValidPartitionFunctionis a valid partition function in the database.


Sign In or Register to comment.