Try VALIDATE DATABASE RECOVER on the database. Then rerun the code. If that doesn't work, post the code here and maybe another several sets of eyeballs on it will resolve the problem.
>I was creating a view programically (sp?) and every time I try to run the procedure to create the view, the program bombs with an error 1522 (connectivity internal consistency error). I checked the ms site and it says to call ms support(?). I don't feel like blowing a incident on a ms problem. I'm using 4 tables to create the view, 1 parent and 3 children. The SQL statement works fine by itself. Any body got any idea's on this one?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05