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

This way:

USE arf_etl

GO

SELECT OBJECT_NAME(object_id) AS referencing_object_name

,COALESCE(COL_NAME(object_id, column_id), '(n/a)') AS referencing_column_name

,*

FROM sys.sql_dependencies

WHERE referenced_major_id = OBJECT_ID('[bmb_ms].[usp_BMBBI_ft_estimated_sale_control_insertupdate]')

ORDER BY OBJECT_NAME(object_id), COL_NAME(object_id, column_id);

GO

USE arf_etl

GO

SELECT OBJECT_NAME(object_id) AS referencing_object_name

,COALESCE(COL_NAME(object_id, column_id), '(n/a)') AS referencing_column_name

,*

FROM sys.sql_dependencies

WHERE referenced_major_id = OBJECT_ID('dbo.bmb_ms.usp_BMBBI_ft_ingredient_consumption_direct_insert')

ORDER BY OBJECT_NAME(object_id), COL_NAME(object_id, column_id);

GO