如何检查SQL服务器中表的更新原因？ [英] How to check why the table is not updating in SQL server ?

问题描述

我们有通过运行正常运行的存储过程，批处理文件和dtsx包来获取数据的表。

We have table which gets data by running stored procedures, batch files and dtsx packages, which is running fine.

现在，我们已将整个数据库与表一起移动，将文件和包发送到新服务器。在这台服务器中，表格没有更新。 

Now, we have moved the whole database along with tables, bat files and packages to a new server. And in this server, the table is not updating. 

我们比较了SP，bat文件和dtsx软件包，一切看起来都不错。此外，在需要的地方更改了服务器名称。

We have compared SP's, bat files and dtsx packages and everything looks good. Also, changed server names wherever it is needed.

有没有办法找出为什么表没有在新服务器中加载，而在旧服务器中正在更新。

Is there any way to find out why the table is not getting load in new server whereas it is updating fine in old server.

提前致谢，

推荐答案

我担心我能给出的唯一答案就是更加努力。这些包是从代理运行的吗？这些工作是否成功运行等？

I'm afraid that the only answer I can give is to try harder. Are these packages running from Agent? Are these jobs running successfully etc?

这篇关于如何检查SQL服务器中表的更新原因？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！