thanks for this feedback. Unfortunately, I do not see this path on my laptop:

C:\Users\myname\AppData\Local\Microsoft\Microsoft SQL Server\100\Tools\Shell

I have SQL Server 2008 R2 Developer Edition installed:

-- Management Studio version...

thanks .. omitted a 'specific' in our original question here... Need permisison to view SQL Server Agent "Job Activity Monitor".

I added the user's Windows Login to both MASTER...

thanks Paul..

Is this also doable via the SSIS 2008 R2 data conversion task.

Would be great to use that task.. in place of the SQL Command w/...

thx Trees -- I've added your suggestions to my toolbox of trix! appreciated!

this is actually a Transactional replication. Would dropping the article THEN re-ADDing the article w/ the new predicate avoid regenerating the ENTIRE Publicaitons snapshot?

From Microsofts instructions:

I like this post: http://www.bradmcgehee.com/2010/03/an-introduction-to-sql-server-2008-audit/

Simple instructions (w/ GUI screen snaps) to setup a SQL 2008:

1) Audit

2) Audit Spec

always nice when the alter-ego resolves the issue...

adding my 2 cents..

on SQL 2008 R2, I've setup a job to UpdateStats on 1 database that is 250GB in used space (400 GB alloc) w/ many compressed...

thank you -- I found her subscriptions using your code! much appreciated

thank you.. now, how might I modify the above solution:

SELECT DATEADD(YEAR,-2,CURRENT_TIMESTAMP)

to render a TIME = all 0's

Lowell - worked perfectly. thanks!

thx ALL.. my bad !

We recently migrated 25 large data warehouse DB's from a single default instance of SQL Server (2005) to a single new, named instance of SQL Server (2008 R2 sp1). Let's...

We have over 150 instances of SQL Server installed on servers. I'd like to identify those instances installed on a VM and those installed on physical machines.. Spiceworks looks...

VMware