thanks Shell.. will try to implement it

Anthony - Do u want me to paste the entire code in Command pane ending with Exec SP???

example -

DECLARE @SQL NVARCHAR(MAX)

SELECT @SQL =

REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +

'EXECUTE schema.procedure;'+CHAR(13)+CHAR(10)

FROM sys.databases WHERE name NOT IN ('master','msdb','model','tempdb')

FOR XML PATH('')

) AS NVARCHAR(MAX)

),

'& # x 0 D ;',CHAR(13) + CHAR(10)

)

--SELECT @SQL

Exec pr_Index @SQL

is this correct???