What they want is an excel with the tables sequence. Does anyone have a script capable of doing this?

The order that I want is just related with fk. No business need

Thank you for the reply. How can we see if we have the same situation on our linked server drivers? Is there any special command to do this?

I have a proc running every day that reorg/rebuild indexes. If reorg then also updates the stats

I have a proc running every day that reorg/rebuild indexes. If reorg then also updates the stats

Probably

This impersonate needs to be grated where ? On AD side or sql?

Hello. Many thanks for that complete answer.

In this case I am searching performance

Hello,

Thank you for the replies.

I would like to get the time that each job took per day to execute. This cam be done on a month analysis.

Suppose I...

Thank you Gail

Thank you for the information Gail

SQL Server 2005 does not recognise that command.

I am not using dynamic SQL

It is not returning everything.

For example:

select distinct(referenced_object_name)

from

(

SELECT OBJECT_NAME(referenced_major_id) AS referenced_object_name

,COALESCE(COL_NAME(referenced_major_id, referenced_minor_id), '(n/a)') AS referenced_column_name

,*

FROM sys.sql_dependencies

WHERE object_id = OBJECT_ID('bmb_ms.usp_BMBBI_ft_cup_and_ingredient_consumption_worktable_insert')

--ORDER BY referenced_object_name, referenced_column_name

)r

Returns...

But if I do like this:

sp_helptext '[bmb_ms].[usp_BMBBI_ft_estimated_sale_control_insertupdate]'

I can see the text inside the procedure