yes, but then you have to remap dbo to sa or you still have the same problem to fix.

Great.

I started one.. but nothing I can share (incomplete/non commercial). Every commercial tool I know doesn't have that level of precision on dependencies (they all use sysdepends which is...

Can't answer that one... but I would suspect that they don't start an infinite loop that loads the cpu until x time has passed

I don't know... I think it's time you start a new post for this new problem (re-explain from the start though).

Do you see any tables listed in that node of the tree??

How are you trying to access the linked server?

Yes.. but those views are very hard to create (because they have so many restrictions).

In case you do not wish to optimize or use an index view, then here's an...

Let's optimize the view first.

Can you send the code, the indexes definition and the execution plan?

You seem to get what he wants. But I don't even know if it's possible to do this at run time...

1 - Still not only 24/7... maybe I forget to close a few browser windows from time to time .

2 - you said...

Please delete the last 2 message of the tripple post .

You need a stored proc for this :

create procedure dbo.GetProducts @MinProdid as int, @MinCatId as int

As

SET NOCOUNT ON

SELECT Products.

, Categories.CategoryName

FROM Categories INNER JOIN Products...

This syntaxe is illegal (or dangerously incorrect).

So if CustomerID = 1 the result from procedure (the statements in the procedure) should be:

SELECT d.DocumentNo, a.AccountNo

FROM Document d, Account a

WHERE d.DocumentNo =...

sorry forgot to tell you... The dts are kept in MSDB.