What happened to "My Posts" for forums?  I don't see it listed.  (Of course it is Monday morning and perhaps the old brain has not fired up yet!!)   thx...

No good.  Brandie's Detective Stories - Tracking Down the Database's Dependents Part 2 --- which has a section on SSIS --- only refers to msdb.  ...

slight tweak to the previous script which had a typo causing an error.. this one works:

DECLARE @SHRINK_DBS NVARCHAR(4000)
SELECT @SHRINK_DBS = CONVERT(nvarchar(max),(SELECT 'USE ' + quotename(name) + ';...

John and Lowell - thx a million.. Your combined solution worked perfectly:

DECLARE @SHRINK_DBS NVARCHAR(4000)
SELECT @SHRINK_DBS = CONVERT(nvarchar(max),(SELECT 'USE ' + quotename(name) + '; DBCC SHRINKFILE (2,25); '...

John - thanks for this solution. I'm having trouble EXECUTING the output from the SELECT USE statement you've provided.   I tried declaring an nvarchar(4000) variable and populating w/ the...

Great info on the VERSIONS option! Thank you.

Found a solution to backup my SSIS Pkg:

- navigate to the SQL Server housing your package(s) requiring BACKUP

- expand Integration Services Catalogs, SSISDB, and your Folder

- right mouse click on...

We'd also like to view SQL 2016 SSRS sample reports.

If anyone knows of any (perhaps querying catalog tables, etc) we'd be interested in downloading them. thanks.

thanks Lowell - I will work with this SQL. Much appreciated!

Resolution is a 2 step fix as you'll need to add the Windows Logins and/or A/D groups that are invoking the SSIS pkg that are INSERTing rows into Oracle ...

thx Sagar -- the query in the link you provided (for SQL 2012) is good if you house pkg's in msdb...

We're housing our SQL 2012 Enterprise SSIS pkg's in the...

this sufficed although it does not list the packages inside projects:

SELECT SUBSTRING(Name, 1, 45) as Name,

SUBSTRING(Deployed_By_Name, 1, 20) as Deployed_By_Name,

...

[font="Courier New"]

Rogue RED X on ReplMonitor for non-existent PUBS / SUBs ---

-- !!! Use this solution at your own risk! It worked perfectly for me, twice to date....

ISSUE: when running Ola Hallengren BACKUPs - Jobs fail with: 64(The specified network name is no longer available.)

--> Regarding the SQL Server backup failures, I followed these...

Our resolution included:

SSMS 2012 Opening a Job step in SSMS 2012 is extremely slow… (30 sec’s to 2 mins)

· Create new role -- do...