Thanks! 🙂

I created a similar MDX script with SSRS on the Adventure Works DW 2008R2 sample database for testing purposes. The result is the same.

The difference between the two scripts...

Thank you for replying.

Actually the two scripts generate the same result. UNION only filter out the same rows but in this case there aren't any. And if I try to...

Hello!

Something like this:

SELECT

CTU.TABLE_SCHEMA + '.' + CTU.TABLE_NAME

,

KCU.COLUMN_NAME [COLUMN],

CTU2.TABLE_SCHEMA + '.' + CTU2.TABLE_NAME [REFERENCED_TABLE],

KCU2.COLUMN_NAME [REFERENCED_COLUMN],

CTU.CONSTRAINT_NAME [FK_CONSTRAINT]

FROM INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE CTU

JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU ON KCU.CONSTRAINT_NAME = CTU.CONSTRAINT_NAME AND KCU.CONSTRAINT_SCHEMA = CTU.CONSTRAINT_SCHEMA

...

You will never get "In Progress" status.

See: http://www.sqlservercentral.com/articles/Administration/howtofindthatjobisrunning/2071/[/url]

Lacc

Missing brackets in DENY example. The correct syntax is:

DENY SELECT () ON Employees TO [MyDOMAIN\Mani]

Lacc