模块“自动回复"取决于缺少的对象"dbo.getresultsdata".该模块仍将创建；但是，直到对象存在，它才能成功运行. [英] The module 'autoreply' depends on the missing object 'dbo.getresultsdata'. The module will still be created; however, it cannot run successfully until the object exists.

问题描述

嗨！我正在创建一个触发器，以允许我向数据库发送请求并进行回复，然后出现以下错误<<<<模块``autoreply''取决于丢失的对象``dbo.getresultsdata ".该模块仍将创建；但是，在对象存在>> ;.之前，它无法成功运行.

触发条件是:

Hi!I am creating a trigger to allow me to send a request to the database and reply,then I am getting the following error<<The module ''autoreply'' depends on the missing object ''dbo.getresultsdata''. The module will still be created; however, it cannot run successfully until the object exists>>.

The trigger is :

CREATE TRIGGER autoreply on dbo.ozekimessagein
FOR INSERT AS
DECLARE @tel varchar(50),@msg varchar(200),@par1 varchar(50),@par2 varchar(50),@par3 varchar(50),@par4 varchar(50)
SELECT TOP 1@tel=sender,@msg=msg FROM ozekimessagein ORDER BY ID DESC
SELECT @par1=s FROM NewSplit('*',@msg) WHERE pn=1
SELECT @par2=S FROM	NewSplit('*',@msg) WHERE pn=2
SELECT @par3=s FROM NewSplit('#',@msg)	WHERE pn=3
BEGIN
execute dbo.getresultsdata @par1,@par2,@par3,@tel
end;

推荐答案

您显然需要存储过程"dbo.getresultsdata".检查以下内容:
检查存储过程是否存在
检查情况:例如，是dbo.getresultsdata还是dbo.getResultData?
检查是否可以访问它( grant [

You obviously need the stored procedure "dbo.getresultsdata". Check the following:
Check if the stored procedure exists
Check the case: For example, is it dbo.getresultsdata or dbo.getResultData?
Check if you can access it (grant[^])

Good luck!

这篇关于模块“自动回复"取决于缺少的对象"dbo.getresultsdata".该模块仍将创建；但是，直到对象存在，它才能成功运行.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！