Lowell (3/3/2010)

---

definitely not normal. foreign key relationships are a best practice.

I've encountered this before, and it seems the companies think that their schema would reveal their business processes ro something,...

Excellent information, Lynn, thank you! Well then I can see that there won't be a lot of activity on our Master database, as we don't do most of those...

Hmmm. That is not a bad idea. I'm not sure how much space we'll be able to get, though.

I have no idea how often, nor by how...

The Master database is set to Full for the...

We're working on doing a code camp here in the new few months. Once that's done I think I'd like to do a SQL Saturday. Most of the...

Good article, Tim. I appreciate the reminder. I think it is true, in most cases, that calling someone out privately is best. I know that I prefer...

Thank you, Steve, for this information.

OK, I may have something. I've looked up the DTSER_FAILURE error and came across this article on Microsoft Support (http://support.microsoft.com/kb/938910). I see that this database server is using...

Steve Jones - Editor (2/19/2010)

---

Go to a job step, properties, advanced. There are places to log, including a table. you can specify a file or a table.

If this is a...

GilaMonster (2/19/2010)

---

Not enough info. The messages are always truncated in the history log. Go into the job, set up a file to log output to and check what's in that...

GilaMonster (2/19/2010)

---

Not enough info. The messages are always truncated in the history log. Go into the job, set up a file to log output to and check what's in that...

I think I will change it to use the sa account. However, I'll wait until I get a good backup of the system databases first.

I'm one of the few at work today.

kevriley (12/11/2009)

---

No it's not because you ran it in the master db - it will report activity across all databases.

It could be that nothing was actually running at that point....