TSQL-Scripts icon indicating copy to clipboard operation
TSQL-Scripts copied to clipboard

Published 20 hours ago • verified publisher icon SQL-Server-projects
→

Metadata

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

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

← Metadata

87
Stars
39
Forks
Watchers

Owner

verified publisher icon SQL-Server-projects

Metadata

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

Back