监控sqlserver2005 DDL *** 作

概述CREATE TABLE dbo.DDLEventLog (EventID INT PRIMARY KEY IDENTITY, EventInstance XML NOT NULL) GO CREATE TRIGGER DDLLogEvents ON DATABASE AFTER DDL_DATABASE_LEVEL_EVENTS AS INSERT INTO dbo.DDLEventLog (E

CREATE table dbo.DDLEventLog
(EventID INT PRIMARY KEY IDENTITY,
EventInstance XML NOT NulL)
GO

CREATE TRIGGER DDLLogEvents
ON DATABASE
AFTER DDL_DATABASE_LEVEL_EVENTS
AS
INSERT INTO dbo.DDLEventLog (EventInstance)
VALUES (EVENTDATA())

-------------------------------------------------------------------------------------------------------------

create vIEw DDL_monitor as select EventID,EventInstance.value('(//Loginname)[1]',  'nvarchar(30)') as 登录名,EventInstance.value('(//Databasename)[1]',  'nvarchar(30)') as 数据库,EventInstance.value('(//CommandText)[1]',  'nvarchar(400)') as DDL语句,replace(EventInstance.value('(//PostTime)[1]',  'nvarchar(300)'),'T',' ') as 执行时间  from lijiwei002.dbo.DDLEventLog union select EventID,' ') as 执行时间  from lijiwei003.dbo.DDLEventLog union select EventID,' ') as 执行时间  from test002.dbo.DDLEventLog

总结

以上是内存溢出为你收集整理的监控sqlserver2005 DDL *** 作全部内容，希望文章能够帮你解决监控sqlserver2005 DDL *** 作所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。