Getting error "Incorrect syntax near 'numeric'" when trying to recover a table using Object Level Recovery.
The problem is that the script generated starts like the one below:
CREATE TABLE [DB].[dbo].[test] (
[id] [numeric](18, 0) IDENTITY [numeric](18, 0) NOT NULL ,
[desc] [char] (2) ...
The problem is the I "[numeric](18, 0)" in the first line. Just removing this code the script works.
,
OLR can not generate identity columns against numeric/decimal columns
WORKAROUND
None
STATUS
Waiting for fix in a future release of LiteSpeed for SQL Server
