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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center