Re: Synonyms - again (Graeme hits again!)

} } In <287gtvINNoou@emory.mathcs.emory.edu> jparker@hpbs2561.boi.hp.com (Jack Parker) writes: } } } >Ladies, Gentlemen, honoured members of the net, } } >We have a cinnamon which goes from one engine on one platform to another on } >another. } } >Last week we had a -934 (connection no longer valid) which turned out to } >be because we had an index on a varchar field. So 'we' changed the columns } >in question to char. I don't know if 'we' re-created the index or not. } } >Today suddenly we get -387 (No connect permission) for this cimmanon. After } >some this and that it turns out that the sillymon had to be dropped and } >re-created - at which point all was well. } } } > Q1) how did this happen? does a simynum work based on tabid or on the } > character name? } } Don't know. } } SE uses tabid. } OnLine uses tabid for local tables, server name + database name } + owner name + table name for remote tables. } } Did you rebuild the table in such a way that the owner name } changed perhaps? (seems unlikely!) On the nose. I just checked and sure enough! the person who changed the table was not the original owner - it now has a different "name". } } } > Q2) is this a documented feature that I missed will STFM (Skimming ...)? } } The above is documented (Guide to SQL: Reference 2-23). A definite RTFM. I should have thought of chap 2 (the second guy) my face is covered w/ egg. Anybody got a towel? } } } graeme } -- } Disclaimer: The author's opinions are his own, and not necessarily } those of Pyramid Technology Ltd. or Pyramid Technology Inc. } --------------------------------------------------------------------------- } -m------- Graeme Sargent Voice: +44 (0)252 373035 } ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 } -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? } -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk } --------------------------------------------------------------------------- } We have the technology. The tricky bit is learning how to use it. } cheers - and thanks j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| Your .sig has expired, please enter jparker@hpbs2561.boi.hp.com | a new one. (208) 396-5388 (W) (208) 384-1623 (H) | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________