I have a table in SQL Server 2005 database.
This table gets updated daily by an unknown process which I'm trying to find out.
I've tried every possible way I know, like:
1. "View Dependencies" by right clicking on the table.
2. SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%INSERT%<TABLE_NAME>%'
3. SELECT OBJECT_NAME(ID),* FROM sys.syscomments WHERE TEXT LIKE '%<TABLE_NAME>%'
4. None of my stored-procedure is encrypted, I've check this by issuing the following stmt:
SELECT * FROM sys.syscomments WHERE encrypted=1
Other things I think would be DTS/SSIS packages, BCP or BULK UPLOAD. I've check out the DTS/SSIS projects sources, but all in vain.
View Complete Post