Viewing 15 posts - 16 through 30 (of 93 total)
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...
May 11, 2013 at 11:59 am
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...
September 9, 2011 at 1:46 pm
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...
June 25, 2011 at 4:59 am
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...
March 23, 2011 at 2:41 pm
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...
February 25, 2011 at 3:53 pm
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,...
February 20, 2010 at 5:19 am
When shutting down, do you turn off any of the agents first or just shut the servers down?
February 19, 2010 at 4:31 pm
Hi there.
I need to do this also. Did you try that order and were there any surprises encountered?
February 19, 2010 at 7:23 am
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...
July 30, 2009 at 10:52 am
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...
November 20, 2007 at 8:27 am
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...
November 20, 2007 at 6:46 am
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...
November 19, 2007 at 10:43 am
Thanks for the response. However, I am still unclear why this would be happening during a database restore.
November 19, 2007 at 5:22 am
Thanks for the reply. I actually meant the option via the Article Property window in the publication GUI.
For example, 'Copy default value specifications'.
Which option in the GUI should be set to True...
July 12, 2007 at 9:18 am
Viewing 15 posts - 16 through 30 (of 93 total)