It is not in my startup parameters. Waht about starting a trace, wouold that trigger it (Profiler).

So would it happen when SQL Agent runs a integrity check? But someone has to set it? I know nobody is doing it manually.

Yep, thats what I am finding out. But do I have to find out if the login has permission to backup and restore or what ever the job is doing?

Thanks for all the advise. It looks like an ugly jobs awaits me and I might as well get after it.

The reasoning behind it is that this database has been around for about 5 years and it has gone through several version and older tables were never cleaned out.

That was news. We are currently on a SAN. So I guess it won't give us anything.

Now with all that said I found about 109 out of 298 tables that lack a Clustered Index. I thought about going through the 109 and adding the primary key...

Thanks for all the great info.

Thank you for the information which helped and the candid insights to my behavior.

Because it has a foreign key to Customer table.

By another table. I know the Customer table does not have foreign keys on it but the employee table referenece the Customer table.

So

SELECT name

FROM sysobjects...

Having said all that the reason for the server 4 being pulled was to replace a processor. I am wondering if that had something to do with it.

they are seperate UPS's. The exact scenerio is that we has plugged the Server4 back into the rack an hadn't had time to hook up the fiber or anything when...

Close but is there way to add in if it's referenced by a foreign key? Example:

Customer has no foreign key but is referenced by the Employee table.

That gave me just the opposite. That is every table with a Foreign Key i want every one without. But then again I could take that temp table and then...