用SQL Server编写的ERP系统，触发器作业未运行
我们是一家制造工厂，运行用 SQL Server 编写的 ERP 系统。我从未使用过 SQL，因此不了解该语言。我所知道的是，正在为我们运行和更新数据的触发器作业现在不再运行。有没有熟悉的人可以回答我有关此的任何问题？？？任何帮助都将不胜感激！
谢谢，
贾娜
We are a manufacturing plant that runs off an ERP system written in SQL Server. I have never worked with SQL and therefore do not know the language. What I do know is that a trigger job that was running and updating data for us, is now NO longer running. Is anyone familiar enough to answer any questions about this for me??? Any help would certainly be appreciated!
Thanks,
Jana
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
好吧，有人可能禁用了触发器，有人可能删除了触发器，或者有人可能更改了触发器。
以下是启用表上所有触发器的代码：
ALTER TABLE mydatabse.dbo.mytable ENABLE Trigger ALL
或者您可以只启用被禁用的一个触发器。
如果这不起作用，那就是另外两种可能性之一。你有备份吗？或所有代码正确存储在源代码管理中，以便您可以在需要时恢复到早期版本。如果您这样做，请找出触发器被更改或删除的原因。它可能会干扰另一个进程，而执行此操作的人员不够专业，无法确定是否仍然需要触发器 init 当前的形式。
well someone could have disabled the trigger, someone could have deleted the trigger or someone could have changed the trigger.
Here is code to enable all triggers on a table:
ALTER TABLE mydatabse.dbo.mytable ENABLE Trigger ALL
or you could just enable the one trigger that is disabled.
If that doesn't work, it is one of the other two possibilities. YOu do have a backup right? or all the code properly stored in source control so you can revert to the eralier verision if need be. If you do though, find out why the triiger was chaged or deleted. Proably it was interfering with another process and the people who did that weren't professional enough to find out if the trigger init's current form was still needed.