I guess I don't need it.

I want all of Dim Time to be updated.

SCOPE(descendants([Dim FMS Heirarchy].[FMS Reporting Hierarchy].[FMSH Financial Page].&[Income Statement],[Dim FMS Heirarchy].[FMS Reporting Hierarchy].[FMSH Financial Page],SELF_AND_AFTER));

This =(ABS(([Measures].[FMSA Monthly Activity].CurrentMember)));

Fore_Color...

OK but is the scoping correct? See link on post.

My values are not getting updated.

Notify multiple operators with difference results

https://sqlhiker.com/2016/07/09/notify-multiple-operators-with-difference-results/[/url]

I'm getting the same thing with my SSMS 2012 and 2014. It seem to start when I added and upgraded Red-gates SSMS Ecosystem Project tools version (1.0.3.4).

I'm running Windows 8.1...

PDF Pages 410-412 for short names

I second this request.

I found this in the log.

Date3/8/2013 8:16:52 AM

LogWindows NT (Red Gate Software)

SourceSQL Doc 2

Category(0)

Event32

ComputerMYPC

Message

CommandLine

Main:Unhandled Exception

System.ArgumentNullException: Value cannot be null.

Parameter name: value

at System.IO.Directory.SetCurrentDirectory(String path)

at System.Environment.set_CurrentDirectory(String...

Answered my own question today.

I setup a new Database trigger:

CREATE TRIGGER [DB_Add_extended_propeties]

ON DATABASE

FOR CREATE_TABLE,CREATE_VIEW, CREATE_PROCEDURE

AS

SET NOCOUNT ON

DECLARE @eventInfo XML

SET ...

Answered my own question today.

I setup a new Database trigger:

CREATE TRIGGER [DB_Add_extended_propeties]

ON DATABASE

FOR CREATE_TABLE,CREATE_VIEW, CREATE_PROCEDURE

AS

SET NOCOUNT ON

DECLARE @eventInfo XML

SET ...

Download SSMS Tools Pack - http://www.ssmstoolspack.com/

then add the following custom script.

DECLARE @type varchar(50), @timestamp DATETIME, @user VARCHAR(100)

SELECT @type=CASE WHEN [type] = 'U'

THEN 'TABLE'

WHEN [type] = 'V'

THEN'VIEW'

...

Thanks for all the great replies. I'm learning alot.

I was working on reviewing extended properties we currently have and forgot to join to sys.objects. I was joined to sys.table. So...

I think you are correct.

I couldn't found a way to list views access history.

The only thing I could find was to run a SQL audit.

I have tried it and it works. SQL 2005 and 2008 R2.