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.

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...

Hi Noel.

I am trying to conduct a test of our BCP. We replicate the database using transactional replication so that we have a backup.

In the event that we have a...

Hi guys. I just sat and passed this exam yesterday. For several reasons, this was my first Microsoft exam in two years and I was quite impressed with the new...

Hi Mark.

This topic is dear to my heart these days as I've recently been charged with BCP for our firm.

One of the guys working with me suggested the use of...

Does anybody know when Microsoft is expected to release this service pack officially? Thanks.

Here is how I troubleshooted this replication problem.

As mentioned already in this thread, we had moved the distribution cleanup job to run once a week, Sunday mornings at 5:00 am...

Sure thing Andy. I will put together the details of my trouble shooting experiences and post it. Would this be too obscure to warrant an article?

I didn't hear back from anybody on this but in the end, I was able to resolve the problem myself. It was a rather obscure issue so I'm not sure...

We just got this message today. I have spent the last 30 minutes googling the error and there seem to be a lot of posts about the issue but I...

Since getting this new job in June 2004, I'm working the most hours I've ever worked before (45 hours/week plus being on call from Sunday night until Friday afternoon) but...

It has been my experience that the optimum study time is around 6 to 8 weeks. If you have no experience with the product (or the component of the product), it could...

I wrote my first program in 1981, while still in high school. My math teacher offered a very basic computer science course (he was learning just ahead of the two...