Repository navigation

TSQL-Scripts

Public

About

🐸 Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.

database-backup foreign-keys fragmentation p6 pmdb primavera refreshview sql sql-server ssdb subscription-owner tsql

108 stars

11 watching

Name		Name	Last commit message	Last commit date
Images/ReadMe		Images/ReadMe
LICENSE		LICENSE
PMDB.Create_Database_Backup.sql		PMDB.Create_Database_Backup.sql
PMDB.Remove database locks.sql		PMDB.Remove database locks.sql
PMDB.Remove orphan project ids.sql		PMDB.Remove orphan project ids.sql
PMDB.Remove user sessions.sql		PMDB.Remove user sessions.sql
PMDB.Restore_Primavera_Backup.sql		PMDB.Restore_Primavera_Backup.sql
PMDB.Update Synonyms.sql		PMDB.Update Synonyms.sql
PMDB.Update the next key to the max.sql		PMDB.Update the next key to the max.sql
PMDB.Wbs formatted names and Udf values in Pivot.sql		PMDB.Wbs formatted names and Udf values in Pivot.sql
README.md		README.md
SSDB.Check_Index_Fragmentation.sql		SSDB.Check_Index_Fragmentation.sql
SSDB.Column_Defaults_List.sql		SSDB.Column_Defaults_List.sql
SSDB.Create_Database_Backup.sql		SSDB.Create_Database_Backup.sql
SSDB.Foreign_Keys_List.sql		SSDB.Foreign_Keys_List.sql
SSDB.Primary_Keys_List.sql		SSDB.Primary_Keys_List.sql
SSDB.Restore_Database_Backup.sql		SSDB.Restore_Database_Backup.sql
SSDB.RowLevelAuditAdd.sql		SSDB.RowLevelAuditAdd.sql
SSDB.Row_Level_Auditing_Add.sql		SSDB.Row_Level_Auditing_Add.sql
SSDB.Row_Level_Auditing_Remove.sql		SSDB.Row_Level_Auditing_Remove.sql
SSDB.Script_Refresh_Views.sql		SSDB.Script_Refresh_Views.sql
SSDB.non-service_accounts.sql		SSDB.non-service_accounts.sql
SSRS.Report_Execution.sql		SSRS.Report_Execution.sql
SSRS.Report_List.sql		SSRS.Report_List.sql
SSRS.Report_Permissions.sql		SSRS.Report_Permissions.sql
SSRS.Report_Subscription.sql		SSRS.Report_Subscription.sql
SSRS.Update_Subscription_Owner.sql		SSRS.Update_Subscription_Owner.sql

Repository files navigation

SQL Server Scripts

Various scripts I use for SQL Server

General Database Scripts

Reporting Services Scripts

Primavera Scripts