SQLYARD

SSIS Catalog Object parameter information script The first query is filtered out for information and the second query is a select * gets you all and you can change to your needs USE SSISDB SELECT pr.name AS [ProjectName], pr.description AS [ProjectDescription], pr.last_deployed_time AS [ProjectLastValidated], pr.validation_status AS [ProjectValidationStatus], op.object_name AS [PackageName], op.design_default_value AS [DefaultConnectionString],pr.deployed_by_nameFROM [internal].[object_parameters] opINNER

Steps to rename a database ( Few ways to do this, this is how I achieve this) Step 1 get the logical and physical name SELECT file_id, name as [logical_file_name], physical_nameFROM sys.database_files  Step 2–Disconnect all existing sessions.USE [master];GOALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATEGO –Change database into OFFLINE mode.ALTER DATABASE SET OFFLINE –Step 3–Log in

USE [msdb]GO/*Create a trigger to send a notification on a status change */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO Create TRIGGER [dbo].[sqlagentjobstatuschange]ON [dbo].[sysjobs]FOR UPDATE AS SET NOCOUNT ON; –** Declare variablesDECLARE @username VARCHAR(50),@hostName VARCHAR(50),@jobName VARCHAR(100),@newEnabled INT,@oldEnabled INT,@jobCreated INT,@bodyText VARCHAR(200),@subjectText VARCHAR(200),@servername VARCHAR(50),@profileName VARCHAR(50) = ‘Add Profile’,@recipients VARCHAR(500) = ‘Add email Address’ –** Set Variables SELECT @username = SYSTEM_USERSELECT

/*Returns a list of missing indexes that SQL Server believes (if added)would result in the highest anticipated cumulative improvementbased on query execution since the last restart*/SELECTCAST((migs.avg_total_user_cost * migs.avg_user_impact) *(migs.user_seeks + migs.user_scans) AS DECIMAL(20,3)) “ImpactFactor”,statement “Table”,N’CREATE NONCLUSTERED INDEX ix_’ +sys.objects.name COLLATE DATABASE_DEFAULT + ” + REPLACE(REPLACE(REPLACE(ISNULL(mid.equality_columns,”) + ISNULL(mid.inequality_columns,”), ‘[‘, ”), ‘]’,”), ‘, ‘,”) +‘ ON ‘

select * FROM [SSISDB].[internal].[packages]  — Get Project ID and Name DELETE from [SSISDB].[internal].[packages] where project_id=and name like ‘%name.dtsx%’  — Change the Name you want to delete