SSDE
文章平均质量分 77
hery2002
这个作者很懒,什么都没留下…
展开
-
SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained
http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspxSQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explainedThe dust has n转载 2008-04-02 10:32:00 · 2371 阅读 · 2 评论 -
Create DDL table in SQL Server 2005 to audit DDL trigger activity
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1312369,00.html?track=NL-417&ad=638703&asrc=EM_NLT_3593059&uid=6118215Robert Sheldon05.05.2008Prior to SQL Server 2005, you could define转载 2008-05-10 08:59:00 · 2023 阅读 · 0 评论 -
Sarbanes-Oxley compliance checklist: IT security and SQL audits
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1312646,00.html?track=NL-416&ad=637013&asrc=EM_NLT_3610732&uid=6118215Michelle Gutzait05.07.2008Problem: My company needs to meet Sar转载 2008-05-10 09:06:00 · 2746 阅读 · 0 评论 -
怎么判断某个库中的某张表在某个时间段有没有被使用过
今天逛论坛,遇到一个经常问的问题,怎么判断某个库中的某张表在某个时间段有没有被使用过?记得以前在Aaron Bertrand的Blog上看到过,去翻一翻,找到了转过来.When was my database / table last accessed? 里面提到了几种方法,列举如下: 1.使用SQL Server审计功能,通过审计功能的记录看判断对应的数据库对象的最后访问时间。USE mas转载 2015-04-18 20:38:36 · 698 阅读 · 0 评论