well I could then check both the indirect and direct relations before I insert a new direct relation. But still have to loop trough a build any new indirect...

I don't think I will be able to force the part < comp. Although I think it is an excellent Idea. I am thinking stored procedure or trigger....

I am guessing but dtore = store.

I used to think storing the path was the was to go, but with what I have been reading about the future of...

Yes, but I also get it on a 2000 machine.

I am going with bug has anyone reported it yet?

the following sp

Proc ==================

CREATE PROCEDURE dbo.StoredProcedure1

AS

Print 'Here 1'

RETURN (Select Count(*) from INFORMATION_SCHEMA.COLUMNS)

Print 'Here 2'

RETURN (Select Count(*)...

Open Visio select new document catagory Database, Database Model Diagram.

Once you have this open goto menu option database -> Reverse Engineer. You will have to create a...

If you have a product like Visio enterprise you can reverse engineer the access db and move it to a sql db and sill maintain the relations, then dts the...

If you have a product like Visio enterprise you can reverse engineer the access db and move it to a sql db and sill maintain the relations, then dts the...

Production system Table With ~1000000 rows ~43000 rows returned, StopTime is part of clusterd index

Case 1

Select M1.StopHistID, M1.StopTime

From MachineHist M1

Inner Join MachineHist M2 On M1.StopTime = M2.StopTime

Group By...