Using DDL triggers to audit events
Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.
2008-05-15
3,467 reads
DDL trigger
2012-07-17 (first published: 2007-11-21)
2,243 reads
RE: Replication to a reporting DB server
Since your reports need to be near real-time, then "log shipping" or "snapshot" replication would be good solutions."Snapshot" replication will not interfere with the reports and is simple enough to setup.
2004-10-01
RE: Table Relationships
You are welcome. If you use something like this make sure there are no gaps in the data. There has to be an entry for every hour of the day otherwise you will get wrong results. We have used this technique several times and it works well. ( although I have not used it to […]
2004-08-29
Return records through a linked server that uses ODBC data source
Hi,I used sp_addlinkedserver to link to a remote server using ODBC(MSDASQL). When I execute select count(*) from LinkSrv.SI.DBO.SIHeader in SQL Query Analyzer. It returns 13705 records. But when I execute select * from LinkSrv.SI.DBO.SIHeader. It only return 885 records. If I specify some columns, select ODCOMP, ODPONO, ODVDCD from LinkSrv.SI.DBO.SIHeader. It returns more records, 1213 […]
2004-08-04
RE: SQL2K not releasing memory
Thank you for your reply.The server has currently got 4Gb RAM, I have tried setting the memory to fixed starting with 0 min to 1536 max. Reason for 1536 is because it is running standard edition and I read it somewhere that it can only access up to 2Gb of RAM, plus the fact that […]
2004-06-03
RE: SQL Server Memory
You need sql2k ent + w2k adv server to make use of extra memory, without them your extra ram in your server is unused.
2004-03-30
RE: Reports are soo slooooowww
Bingo!!! That is what I saw too. Here is the deal though. According to Adobe tech documents, PDFs are suppose to be able to open within a browser (http://www.adobe.com/support/techdocs/98fe.htm). However, I have been VERY unsuccessful with getting this to work. I have uninstalled Reader, installed the latest version, and I be darned if it doesn't […]
2004-03-08
RE: Worst Practice - Triggering External Events
Ok... you've convinced me... I was implementing a trigger that would email if certain rules were met.I'm not saying that sending notifications to users (or running some other process) on data change is a bad idea. Although I think this is not the best way to handle things, that's a separate discussion. I'm focusing on […]
2004-02-23
How does defragmenting o/s affect SQL Server?
I am considering running Diskeeper in the background on a NT4 server containing a SQL Server instance. How will this affect the databases? There are Maintenance plan jobs in place for optimisation and integrity checks. I was wondering if anyone had opinions on the cumulative effect of re-organising the data/indexes in these jobs as well as defragmenting the files […]
2004-02-23
43 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers