November 21, 2007 at 8:15 am
A couple of days ago, this table(DS_InternalData_BI2k.db_audit.audit_200710231434316620) was deleted from "User Tables". Now the following production job is abending, it's looking for the table and the data that is being inserted has nothing to do with that table. Also, 'audit_tr_200710231434316620' is still in the sysobject table. Thanks in advance for you any help!
INSERT INTO [dbo].[Active_Directory](
load_date,
[UID],
[email_addr],
[full_name],
[f_name],
[l_name],
[MI],
[Phone_num],
[Department]
)
SELECT
getdate(),
[UID],
[email_addr],
[full_name],
[f_name],
[l_name],
[MI],
[Phone_num],
[Department]
FROM [dbo].[Active_Directory_R]
where len(uid) <= 6
Error Msg:
Server: Msg 208, Level 16, State 1, Procedure audit_tr_200710231434316620, Line 27
Invalid object name 'DS_InternalData_BI2k.db_audit.audit_200710231434316620'.
November 21, 2007 at 8:29 am
I guess the object audit_tr_200710231434316620 is a trigger which might be using the this object DS_InternalData_BI2k.db_audit.audit_200710231434316620.
--Ramesh
November 21, 2007 at 8:33 am
Can/should I delete the object audit_tr_200710231434316620 from system?
November 22, 2007 at 12:05 am
Do NOT delete any objects from production database unless you are fully aware of the impacts of that object.
I suggest you to first approach the person who has deleted this object and inform him about the consequences of it.
Take the backup of the database before doing anything to avoid any future troubles.
--Ramesh
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply