GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — GitHub - SQL-Server-projects/TSQL-Scripts: :frog: Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.

BranchesTags
Open more actions menu

Latest commit

 

History

102 Commits
102 Commits

Folders and files

NameName
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

License: MIT current_build SQL_SERVER_2016

General Database Scripts

  • Check Index Fragmentation
  • Database Backup
  • Database Restore
  • Column Defaults List
  • Foreign Keys List
  • Primary Keys List
  • Refresh Views
  • Row Level Audit Add
  • Row Level Audit Remove

Reporting Services Scripts

  • Execution
  • Permissions
  • Report List
  • Subscriptions
  • Update Subscription Owner

Primavera Scripts

  • Database Backup
  • Database Restore
  • Remove Database Locks
  • Remove Orphan Ids
  • Remove User Sessions
  • Update Synonyms
  • Update Next Key Value
  • WBS User Defined Values In A Pivot

About

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

Topics

database-backupforeign-keysfragmentationp6pmdbprimaverarefreshviewsqlsql-serverssdbsubscription-ownertsql

Resources

Readme
MIT license
Activity
Custom properties

Stars

108 stars

Watchers

11 watching

Forks

52 forks
Report repository

Releases

Packages

Contributors

Languages

You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.