With SQLYog 5.21, I exported database as sql statements to move db to another server . In some of the stored procedures, the leading character in the table name was changed to the letter i. Here's an a snippet of the incorrect extract with the changed characters in bold:
inner join iecurityobjects so
on so.ReferenceId=p.projectid and so.SecurityObjectTypeId=$projectTypeid
inner join ilsecurityobjectsecurityobject rlsoso
on so.SecurityObjectId=rlsoso.SecurityObjectIdChild
inner join ilsecurityobjectsecurityobject rlsoso2
If I export it with sqlyog 5.19, the extract is correct:
inner join securityobjects so
on so.ReferenceId=p.projectid and so.SecurityObjectTypeId=$projectTypeid
inner join rlsecurityobjectsecurityobject rlsoso
on so.SecurityObjectId=rlsoso.SecurityObjectIdChild
inner join rlsecurityobjectsecurityobject rlsoso2
What could explain this? There are other stored procedures in this same db that reference the same tables, but the names are correct.
Thanks for your help.
Donna
