i am not a dba

John: Where exactly do you want me to check for that "..deny'''

Also on another server/database I get this .....

Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 112

No global profile is configured. Specify a profile name in the @profile_name parameter.

I beleive...

I believe this must be a permissions issue right ?

Msg 229, Level 14, State 5, Procedure sp_send_dbmail, Line 1

The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema...

Yes I need the trick

God Blesses those who bless others..

Amen and Thank You

Pardon my ignorance.

I didn't even know there was a sys.foreign_keys in existence.

So how would I ask you that ?

I didn't think you would be needing a constraint name..

Agree

You didn't forget..

However I needed it and you probably assumed I knew it.

Either way, I did not know how to get it

Agree!

Actually Lowell and Lynn get the credit!

Why ? Lynn provided the final statement that I needed, but then forgot to tell me how I would get the name of...

Tell me how to get the value of <fk_constraint_name>

FOUND THE MISTAKE.. ALL Set ....

Select object_name(SI.object_id) as tab_name,

( Select c.name from sys.columns c where object_id = SI.object_id AND c.column_id = SIC.column_id ) as [index_col_name]

from

sys.indexes SI

inner...

Yep, works, thanks...

I changed it here and there ...

May I ask whether we could also do a similar query to identified PRIMARY keys ???

select distinct

A.name as tab_name ...

Ok I need the fourth column as well,

I modified your query works well, but need more info ( last key piece is missing )

select distinct

A.name as tab_name ,...

Yes,

But had to change it slightly...... ( Yours, the first 2 columns had the same values )

select fk.name as FKName,

object_name(fk.parent_object_Id) as TableName,

object_name(o.object_id) as REFName, fk.*

from sys.foreign_keys fk

inner...

It took 1 MIN and 40 seconds

Table 'HCDAXP'. Scan count 9, logical reads 896088, physical reads 157, read-ahead reads 899182, lob logical reads 0, lob physical reads 0, lob read-ahead...