I've made quite a bit of progress (after many hours) and have learned much in the process.

I now have the lab environment setup except that my VMs have no internet...

Hi.

I'm in the midst of setting up the lab environment. I have a server borrowed from work with 8 GBs of RAM and 140 GBs of hard drive space. I've...

Hi George.

Did you ever resolve this? I have a similar situation in which I have created a TVF for a user who I do not want to grant CONTROL SERVER...

We've recently implemented auditing in our shop. In terms of head count, server count and application count, I suspect we are smaller than most. However, we're a financial firm and...

For those of you who are interested, it turns out I was missing something here.

The particular group I was auditing against in this case actually has sysadmin privilges and as...

When interviewing for my current job, one of the questions was "What first attracted you to your wife?".

Not having any clue how to answer this properly, I decided to go...

Thanks again.

On the publisher, I have turned off all the log reader agents. This can be done once per replication database no matter how many publications there are. That is,...

When shutting down, do you turn off any of the agents first or just shut the servers down?

Hi there.

I need to do this also. Did you try that order and were there any surprises encountered?

I figured out the problem.

This alert, number 20575, is not configured by default to be event-logged. I eventually found this out by running the following SQL ...

SELECT * FROM sys.messages...

Thanks.

Hello again.

I took your suggestion and made it work. I added two new steps to the daily backup job for the databases having the trigger. The first new step disables...

Hi Brandie. Thanks for the response.

My approach was to create a database DDL trigger on select databases and have the trigger log the changes to a common database, DB_AUDIT.

I didn't...

Hi Steve,

Thanks for responding.

I must admit that I am still confused, however. If I have set up a DDL trigger with database scope (as opposed with server scope), then how...

Thanks for the response. However, I am still unclear why this would be happening during a database restore.