为什么不能创建这条存储过程? 求高手帮忙在线等!

[yiyezhiqiu]

CREATE PROCEDURE dbo.dataimport AS

exec sp_addlinkedserver @server='songorder9',
@srvproduct=N'',
@provider=N'sqloledb',
@datasrc=N'192.168.72.16'
go
exec sp_addlinkedsrvlogin 'songorder9','false',null,'iavp','iavp'
go
--用户名称admin且没有密码登陆链接服务器。

INSERT INTO FeeCheckout.dbo.c_CallLog
SELECT *
FROM songorder9.iavpdb.iavp.c_CallLog
WHERE (Day(getdate()-1) =Day(EndTime)and (month(getdate())-1)=month(EndTime))
--)
exec sp_helpserver
exec sp_dropserver songorder9
go
--删除连接服务器

AS后面的部分在查询分析器里面都能执行,主要功能是从一台机器的数据库里面导数据到本机器 ,但如果创建为存储过程系统就提示 "异类查询,需要连接设置 ANSI-NULLS和ansi_warings" 等信息,请教高手是怎么回事!谢谢大哥们!

[pbsql]

CREATE PROCEDURE dbo.dataimport AS

exec sp_addlinkedserver @server='songorder9',
@srvproduct=N'',
@provider=N'sqloledb',
@datasrc=N'192.168.72.16'
exec sp_addlinkedsrvlogin 'songorder9','false',null,'iavp','iavp'
exec('
INSERT INTO FeeCheckout.dbo.c_CallLog
SELECT *
FROM songorder9.iavpdb.iavp.c_CallLog
WHERE (Day(getdate()-1) =Day(EndTime)and (month(getdate())-1)=month(EndTime))
exec sp_helpserver
exec sp_dropserver songorder9
')
go

[yiyezhiqiu]

pbsql(风云) 大哥的方法果然见效 我还象将这里面的 getdate()-1换成我传进来的，这里如何写呢

[zjcxc]

CREATE PROCEDURE dbo.dataimport AS

exec sp_addlinkedserver @server='songorder9',
@srvproduct=N'',
@provider=N'sqloledb',
@datasrc=N'192.168.72.16'
exec sp_addlinkedsrvlogin 'songorder9','false',null,'iavp','iavp'
declare @s vrchar(10)
set @s=convert(char(10),getdate(),120)
exec('
INSERT INTO FeeCheckout.dbo.c_CallLog
SELECT *
FROM songorder9.iavpdb.iavp.c_CallLog
WHERE (Day('''+@s+''') =Day(EndTime)and (month('''+@s+''')-1)=month(EndTime))
exec sp_helpserver
exec sp_dropserver songorder9
')
go

[davytao1018]

CREATE PROCEDURE dbo.dataimport
@time datetime
AS
...
set @s=convert(char(10),@time,120)
...

[yiyezhiqiu]

谢谢各位大哥们！