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

skelly

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..

thx,
sk

Brian Donahue

Hello,

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?

skelly

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...

thx,
sk