--重新创建此存储过程,不过在前面加上set ANSI_NULLS on goset ANSI_WARNINGS on goCREATE PROCEDURE sp_test AS set XACT_ABORT on set nocount on begin transaction insert into table1 select * from server1.DB1.dbo.table1 commit transaction set nocount off GO
--重新创建此存储过程,不过在前面加上set ANSI_NULLS on和set ANSI_WARNINGS on,系统创建存储过程时,默认是off --在查询分析器中执行如下代码drop procedure sp_test goset ANSI_NULLS on goset ANSI_WARNINGS on goCREATE PROCEDURE sp_test AS set XACT_ABORT on set nocount on begin transaction insert into table1 select * from server1.DB1.dbo.table1 commit transaction set nocount off GO
--重新创建此存储过程,不过在前面加上set ANSI_NULLS on和set ANSI_WARNINGS on,系统创建存储过程时,默认是off
--在查询分析器中执行如下代码drop procedure sp_test
goset ANSI_NULLS on
goset ANSI_WARNINGS on
goCREATE PROCEDURE sp_test
AS
set XACT_ABORT on
set nocount on
begin transaction
insert into table1 select * from server1.DB1.dbo.table1
commit transaction
set nocount off
GO