DCPeterson (6/10/2008)

---

The most common problem I've seen when it comes to audit logs is that the requirements aren't well defined so you get something like this: "well, we don't know...

This is why I did not mention...

Lee,

I'm glad I'm not in that position. This impacts how you allow users to query the data as well. I would think the easiest way to implement this...

[sarcasm]Wow a failed SAP implementation, I've never heard of that before![/sarcasm]

Nice series. I think the key is knowing what to log and why. I have been involved with logging where everything was logged because we could and I...

In my experience the biggest reason for software project failures has been a lack of "buy-in" by the people who will be using the software and lack of true support...

The question did not ask you to assign it to 0. The reason the word "consistently" is...

If you restored the database on the DEV server from a backup on the PROD server you probably want to update the statistics for one. As you can see...

Do you mean a count of the # of rows in each table in a database? Either of these will work although the second would the recommended approach in...

Not sure what you mean by disk consumption but the article, http://www.sqlservercentral.com/articles/Operations+Manager/63041/, includes a query which gets database file sizes using MOM.

It helped me even if it doesn't help the OP.

Yes, I could not remember where I had seen Grant's article. I thought it has been posted on SSC, but I could not find it. It is a...

You need a comma "," after DailyReading. Then it should at least parse.

You would need to use dynamic sql and even then I am not sure is would work. Something like:

Declare @sql varchar(max)

Set @sql = 'insert into ' + @dbname +...

Checking everything is part of the job. First things to look for are Table Scans and Clustered Index Scans(basically a table scan). If you can eliminate these you...