I used the sql source to rebuild the databasse, and recently I found some errors about aduit.
Then I login into the sql server and I find all the audit tables are missed.
I try to fix it by running "exec dbo.spSqlBuildAllAuditTables;" and it gives me one error
(the message is described in Chinese and it looks like) :
"dbo.ACCOUNTS_CSTM_AUDIT" can't be found because the object doesn't exist or you don't have the right to access it.

The dbo.ACCOUNTS_CSTM table is modified and has about fifty columns now.

Can you give me some suggesting to fix it?

After my posting here, I try to create dbo.ACCOUNTS_CSTM_AUDIT manully, then "exec dbo.spSqlBuildAllAuditTables;"  can create other audit tables successfully. My guess would be I use some special word that would stop the procedure.

Thank you very much.

Yes, about fifty fields. I think it's the problem that you mentioned. Anyway, I fix it by creating audit table manually. It works now.

Thank you!