Find invalid objects: false positive on $PARTITION statement

Provides intelligent code completion for SQL Server editors.

Find invalid objects: false positive on $PARTITION statement

Postby weswinkler » Fri Aug 03, 2012 5:41 pm

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:
Code: Select all
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.
Posts: 34
Joined: Tue Nov 11, 2008 7:12 pm

Postby Brian Donahue » Mon Aug 06, 2012 12:59 pm

Thanks for letting us know. I have logged a bug report with the development team as SP-4488.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests