Thanks for the info. I'm used to working in 2000 and usually just check sysobjects where xtype = 'u' . I see where in 2005, the col is...

Thanks for posting this article - I didn't know this trace was out there.

Does anyone have any suggestions as to why my default trace doesn't show up?

I'm a...

Hey thanks for the suggestions!

I'm pretty sure I have the basics working fine, now.

I do have one additional question. You wrote: "You can then have the job update...

Thanks, everyone! At my last place, we included the integrity checks in the maint plan. I'm not sure why they don't do that here.

Next question......

I have another question about checkdb. I just started at a new employer and am wondering about a nightly job that I found. Here's the only thing...

But my ObjectID is null also. Is there a command I need to run so that ObjectID isn't null?

I still am getting results from all tables, but I found out something more...

I added the following events so that I could see the ObjectID and ObjectName columns in my...

I'm just not following this. I thought I set up my filter correctly, but yet I'm getting queries from the entire server.

I know the ObjectID for my table is...

Joe - to follow up on your earlier example - Hugo Kornelis, based on an example from Adam Mechanic...

I can understand why it doesn't work, but I'm wondering why EXISTS...