From your second link:

"...Since you are using PAE, it is not recommended you still turn on /3GB switch.

As we know, using /3GB will cause the OS to have only 1GB...

We don't use sp_OACreate, so the first article you mentioned doesn't look like it applies.  I tried going to your second link but it was blocked by our Firewall.  Trying...

It's not that I don't understand what SQL Bill is saying...It's that I've never seen an ACTIVE transaction log be double the size of the DB...Typically it can grow to...

Along these lines...

I have a production DB environment that does massive calculations.  The data file is 25G in size, yet the logs are 50G.  We've verified that the system is...

Actually, using SQL 2005 I think I'm on the verge of figuring this out using an Event Notification.

However, I'm stuck.  I'm trying to use the trace event AUDIT_DATABASE_OBJECT_ACCESS_EVENT , but...

Could you create a trace (to emulate Profiler) to do it?

What about Notification Services?

On principal I would agree.  But, the fact of the matter is there are many more AD Admins here than people who have access to SQL Server.  Probably even more...

There's specific information like EmployeeID, Name, Address, etc that we want to store in AD.  Right now we have processes set up that dumps the data to a text file...

The Aethyr Dragon:

What database system was that?  What AV engine did you have on the server?

Thanks,

Mike

That's a good question.

It's more of a question of maintenance and overall protection...And, the assumption that virus/spyware/malware developers *WILL* at some point create a virus that uses a common DB...

Thanks Jo...I had already read that article, but appreciate you pointing it out.  I had read it a few weeks ago and just re-read it as a refresher...

Given that we...

Wow.  Thanks for the info.  I'm shocked that our server group put Win2K Standard on a server that had 4GB of RAM...At least I know what the issue is now. ...

Joseph:  Yeah, I was very surprised at how little Lumigent did...I thought the auditing was at a much different level, but from what the sales guy said I wasn't impressed...

So, it doesn't sound like this works "perfectly"...

If the plan is to check the jobs on a daily basis, have any of you considered writing a webpage to go out...

Phill:

interesting, I guess I should have expected that to be the case.  I was also just realizing that we could use the Quest server as the MSX.