Received Error - Incorrect syntax near 'i' at position 58 when execute xp_objectrecovery_executeselect with keyword "in"
Example:
EXEC xp_objectrecovery_executeselect
@filename = 'C:\example.bak',
@scripttext = 'select * from dbo.table where key in (6710005,6702105,6702154,6739199)',
@destinationtable = 'dbo.table',
@destinationdatabase = 'TABLESAVE'
go
Result:
LiteSpeed(R) for SQL Server Object Level Recovery 6.5.2.1042
Copyright 2011 Quest Software, Inc.
Msg 0, Level 16, State 1, Line 0
Line 1: Incorrect syntax near 'i' at position 58.
Software Defect
WORKAROUND:
None.
STATUS:
Waiting for fix in future verison of LiteSpeed.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy