可以在触发器中加上如下语句
declare @msg varchar(100)
set @msg = '有新消息了,请各位注意'
set @sql = '''net send all ' + '' + @msg + ''
exec('master.dbo.xp_cmdshell ' + @sql )
declare @msg varchar(100)
set @msg = '有新消息了,请各位注意'
set @sql = '''net send all ' + '' + @msg + ''
exec('master.dbo.xp_cmdshell ' + @sql )
ON dbo.employee
FOR INSERT/* INSERT, UPDATE, DELETE */
AS
create table #table(id int identity,txt varchar(1000))
select @cmdStr='ping '+@@hostName
insert into #table(txt) exec master..xp_cmdshell @cmdStrselect substring(txt,charindex('[',txt)+1,charindex(']',txt)-charindex('[',txt)-1) from #table where id=2
declare @sendstr varchar(100)
select @sendstr='net send '+@HostName+'Messages!'
exec master..xp @sendstr
CREATE TRIGGER employee_Trigger
ON dbo.公告信息
FOR INSERT/* INSERT, UPDATE, DELETE */
AS
declare @msg varchar(100)
set @msg = '有新消息了,请各位注意'
exec('master..xp_cmdshell '' net send all 请各位注意新消息了 ''')