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

Unable to save database snapshot - Found a low surrogate....

skellyskelly Posts: 3
edited March 10, 2006 10:58AM in SQL Compare Previous Versions
I am trying to create a snapshot of my database...

I wanted to get to the bottom of this error so I deleted every record out of every table in my database and this error still is appearing..

I believe the problem is not with the data (because there ain't none!)

Now what should i do..



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    I agree entirely that the data would not cause this problem in this case as you're only comparing schema. In the past, this issue was caused by extended properties that have invalid data. Does the database make extensive use of extended properties?
  • Options
    hi, thanks for the reply...

    as far as extensive use of extended properties...

    There are no user defined data types however

    in the 'Creation SQL' tab there are many (hundreds per table!) extended properties listed. I didn't explicitly create these properties but they are in there.. if the snapshot creator could give me a clue as to where it crapped out then i could isolate my problem..

    any help is appreciated...

Sign In or Register to comment.