Auditing in SQL Server 2005&2008

于 2011-04-25 18:26:00 发布
阅读量191 收藏
点赞数
分类专栏： SQL Basic Knowledge 文章标签： sql server triggers table
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/envykok/article/details/6362311
版权

Audits on MS SQL Server 2008

http://www.sql-server-performance.com/articles/audit/2008_audit_intro_p1.aspx

**The Audit feature is supported only in Enterprise and Developer editions of SQL Server 2008

 

Introduction to Change Data Capture (CDC) in SQL Server 2008
http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-(cdc)-in-sql-server-2008/

**Change data capture is available only on the Enterprise, Developer, and Evaluation editions of SQL Server

 

 

Auditing using DDL Trigger in SQL Server 2005

http://blogs.msdn.com/b/sqlserverfaq/archive/2008/12/16/did-you-know-auditing-using-ddl-trigger.aspx

 

DDL Triggers in SQL Server 2005

http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx

 

Introduction to DML Triggers

http://www.sqlservercentral.com/articles/Triggers/64214/

envykok
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Pro SQL Server 2012 Practices
04-08
Pro SQL Server 2012 Practices is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of ...
sql server 2016 评估下载版
03-22
- **SQLServer2016-SSEI-Eval.exe**：这个文件是SQL Server 2016评估版的安装程序，它提供了90天的免费试用期，让用户在实际部署前充分测试其功能和性能。 总之，SQL Server 2016是一个全面升级的数据库系统，其新...
Securing SQL Server(Apress,2016)
10-28
Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against ...
Healthy SQL.pdf
02-07
Microsoft SQL Server has become an eminent relational database management system (RDBMS) in the marketplace. The SQL Server engine has come a long way from being just another RDBMS; it’s an end-to...
sql动态行转列的两种方法
09-10
这两种方法都是针对SQL Server的，因为`PIVOT`是SQL Server特有的功能。对于不支持`PIVOT`的数据库系统，如MySQL，可以使用自定义的SQL语句或者编程语言（如Python、Java等）来实现类似的功能。 总之，动态行转列在...
sp_who/sp_who2
05-24 394
sp_who/sp_who2 [ [ @loginame = ] login | session ID | ACTIVE ]sp_who returns a result set with the following information. Column Da
迅速获得表的行数- SQL SERVER
05-30 186
(1) 方法一SELECT O.NAME,I.ROWSFROM SYSOBJECTS O INNER JOIN SYSINDEXES I ON O.ID=I.IDWHERE i.INDIDORDER BY O.NAME (2)方法二 待补充...
SQL 随机数
05-25 153
SQL 随机数 select  floor(rand()*100); --求随机数据 Solution 1 : SELECT TOP 1 * FROM [tablename] ORDER BY NEWID() Solution 2 :Declare @ID INTSELECT @ID=floor(rand()*100) SELECT TOP
字符串和子字符串的问题
05-25 149
已知字符,求字符串位置 SELECT charindex(est, testing)  -----------2(1 row(s) affected)  已知字符位置,求字符串 SELECT SUBSTRING(testing,1,3) ----tes(1 row(s) affected) 
Order of tigger, constraint and user query
10-24 146
'...If constraints exist on the trigger table, they are checked after the INSTEAD OF trigger execution and before the AFTER trigger execution.'( comes form http://msdn.microsoft.com/en-us/library/ms189799.aspx)'...AFTER AFTER specifies that the DML trigge
Rename table & index in SQL 2008
08-02 139
<br />sp_rename 'tablename','new table name' <br /> <br />sp_rename 'table. index','new index name','INDEX'
Update query with inner join
08-10 136
<br /><br />Sample:<br /><br />UPDATE         AliasA<br />SET                CarMaker = mstMakerModel.Maker<br />FROM            tblCarAuctionList AS AliasA INNERJOIN<br />                      mstMakerModel ON AliasA.CarName = mstMakerModel.Model <br />
Update Top N rows in sql server 2005
06-07 135
<br />-- USING TOP(N) WITH UPDATE OPERATION<br /> UPDATE TOP(10) tablename SET NAMES='AAAAAA'
SQL And Statistics
12-12 128
/****** Object:  Index [LISTINGFEED_ID_LISTING_IDUN]    Script Date: 12/10/2010 22:22:40 ******/ statistice helping the optimizer cost base     -    sys.stats     -    DBCC SHOW_STATISTICS(table_name,statsname) auto-generate statistics will be single
Get Database Create by Who and When in SQL SERVER
07-27 120
USE [master] <br /> GO<br /><br /> select l.name AS created_by ,d.name,d.create_date from sys.databases d <br /> inner join sys.syslogins l on d.owner_sid=l.sid <br /> where d.name='dbname '<br /><br /><br />
SQL replication
07-19 119
<br />(1) 在SQL SERVER Instance A 创建publish (源）<br /> <br /><br /> <br /><br /> <br /> <br />(2) 在SQL SERVER Instance B 创建subscriber（目标）<br /> <br /><br /> <br />
大学物理-章节PPT！
最新发布
07-22
大学物理-章节PPT！
将当前路径下的doc或者docx转化为doc/docx
07-22
将该脚本放在要转化doc/docx的路径下，执行
SQL Server 2016：高性能与关键任务优化
"SQL Server 2016 Mission Critical Performance White Paper" 本文是关于Microsoft SQL Server 2016的一项技术白皮书，主要探讨在数据量和复杂性不断增长的背景下，如何实现关键任务性能的提升。白皮书详细介绍了...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值