Yes,
you can use function in report with parameter @user (its default in ssrs). In database where you have data add mapping data to user and at report visibility...

Yes, i found it, must be "table options"

Maybe try this:

Tables:

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*

FROM sys.dm_db_index_usage_stats

WHERE database_id = DB_ID( 'db_name')

AND OBJECT_ID=OBJECT_ID('table_name')

Procedures:

SELECT * FROM sys.objects

WHERE TYPE = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 7

Databases:

WITH agg AS

(

...

On standard version you can create procedure with coursor and update data (set parameters) and run subscriptions

Jeff Moden (1/26/2016)

---

It's a real shame that so many people believe that xp_CmdShell is a security risk but then will let anyone run PowerShell and still not get the data...

Read it:

https://www.mssqltips.com/sqlservertip/2675/why-cant-i-restore-a-database-to-an-older-version-of-sql-server/

"Script out the objects from the newer database and then usp a bcp process to extract the data from the newer database and import it into the...

You must first get list of services name

sc query type= service state= all |find "SQL" |find /V "DISPLAY_NAME" |find /V "AD" | find /V "Writer"

here is result from my uat

SERVICE_NAME:...

Maybe like that:

sc query MSSQLSERVER

or

Wmic service where (PathName like '%Binn\\sqlservr%') get caption, name, startmode, state, PathName, ProcessId

You can check status of subscription like this:

SELECT DISTINCT

E.NAME ,

E.PATH ,

D.DESCRIPTION ,

LASTSTATUS ,

EVENTTYPE ,

LASTRUNTIME ,

DATE_CREATED ,

...

I change expression to: =SWITCH(sum(Fields!CARMEN.Value)=0,True,False,InStr(JOIN(Parameters!POKAZ.Value,","),"CARMEN")>0,False,True) and it works

Yes 🙂

1 create manualy subscription and run it

2 create job whit command eg:

-- This procedure get data from table [name and email adres] then update subscription and run subscription, wait...

big thx 🙂

You can try it:

Search subscription id for your report

SELECT

A.SUBSCRIPTIONID

FROM REPORTSERVER.DBO.REPORTSCHEDULE A

JOIN MSDB.DBO.SYSJOBS B

ON CAST(A.SCHEDULEID AS VARCHAR(40)) = B.NAME

JOIN REPORTSERVER.DBO.REPORTSCHEDULE C

ON B.NAME = CAST(C.SCHEDULEID...