2

Trying to install sp_BlitzCache on SQL Server 2008, I get:

Msg 102, Level 15, State 1, Procedure sp_BlitzCache, Line 2705 Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Procedure sp_BlitzCache, Line 2715 Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Procedure sp_BlitzCache, Line 2865 Incorrect syntax near '.'.

Line 2705 is :

/* END Testing using XML nodes to speed up processing */

Line 2865 is the FROM line in:

/* Set configuration values */
SELECT  @ctp = NULLIF(CAST(value AS INT), 0)
FROM    sys.configurations
WHERE   name = 'cost threshold for parallelism'
OPTION (RECOMPILE);

It appears to be version 5.5

The SQL Server version is 10.0.6000.29.

When I page through the code, the first error I see highlighted is on #1162 in the source file: (and 4 more after that.)

SELECT CAST('' AS XML).value('xs:hexBinary( substring(sql:variable("@individual"), sql:column("t.pos")) )', 'varbinary(max)')
"Cannot call methods on int."

The next error is on line 2032 in the source - a select statement with

q.n.query('.') AS statement
Can't find q as a column, function, or q.n.query is ambiguous.

After that there are more cascading errors.

0

1 Answer 1

5

You're running it in a database in 2000 or 2005 compatibility level, which isn't supported.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.