Its probably happened when there was a timeout when you were updating a table after adding or dropping a field. When the table restructures the Tn table gets copied to a new table TnA with the new table structure, copies the contents of Tn to TnA, and then drops Tn and renames TnA to Tn. Something in between might have failed and you probably now have a table called T885A in your database.
Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Longwing, Lj Sent: Thursday, June 20, 2013 3:52 PM To: [email protected] Subject: Re: Lost view in Database of T852 ** And turn on sql logging while saving the form will tell you what the create statement is doing and hopefully give you a better idea as to why the errors are occurring On Thursday, June 20, 2013, Eamonn O'Riordan <[email protected]> wrote: > I seem to have lost a view in the database. > > The error message I'm getting is > > ARERR [552] Failure during SQL operation to the database : Could nand turnot use view or function 'T885' because of binding errors. (SQL Server 4413)Invalid object name 'T852'. (SQL Server 208) > > This happened before about 5 years ago and the solution was to save the form again which rebuilt the view. Unfortunately, since 5 years ago, auditors have restricted the visibility of the database and I can't figure out which forms relate to T852 and T885. Anybody able to offer a suggestion? Thanks Eamonn > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
