You are here: troubleshooting data updates « MsSQL Server « IT news, forums, messages
troubleshooting data updates

Posted by KR on 03/07/06 00:22

I don't know if the title for the subject is appropriate here, anyway
here goes:

This process was set up by someone and I have inherited it. I have a
sql2000 database that has about 13 tables that get populated with data
from 3 different databases. I have identified where each of this data
comes from, and the stored procedures that do the updates, inserts, and
deletes, and the jobs that run these stored procedure to do the
updates, except for one table. The updates for all the other tables
are done through scheduled jobs. For the one table I know where the
data comes from and the stored procedure that needs to run to do the
update on the table, however I have not been able to identify the
process that runs the stored procedure.

I am hoping that someone can give me a clue as to how to find out where
a stored procedure is being used - or any other hint as to how I could
go about finding out how this table gets updated.

Thanks
KR

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация