What are the challenges you face when working across database platforms? Take the survey
Options

Error deleting data from table before generation

elsioelsio Posts: 4
edited December 15, 2014 10:39AM in SQL Data Generator
Hi,

I'm having the following error while generating data with the option "Delete data from table before generation" active:
"Parameter 3 is incorrect for this DBCC statement. The statement has been terminated."

I used a profiler to check the statement executed on SQLServer
DBCC CHECKIDENT ('table_name', RESEED, -2147483649) WITH NO_INFOMSGS
The table that i'm trying to generate data has a column (primary key) with the following identity specification: IDENTITY(-2147483648,1)

Any ideas about this error?

I really appreciate any help you can provide.

Thanks

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post and sorry for the error.

    Can you please reply my email with the table creation scrip for this table and depending other objects? I would like to replicate the issue here.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.