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.

See more:

SQL

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;