Technical Knowledgebase - SQL
Scripts, maintenance plans, queries, and more!
- User Left Organization, User Came Back and Now Can't Login to the Portal
- How to schedule a full backup of SQL databases
- Retrieving the list of URL links from Product Procedures - TSR
- Retrieving the list of links from Products and Services - TSR
- SQL Script: Page Subscriptions Report
- Locating tabbed islands that have tabs with no island on them.
- No Users Showing For System Permissions
- How to change OnSemble Database new login or password.
- Getting information about your LMS courses from SQL - TSR
- Set ALL user profile policies in SQL
- Setting all alerts for primary consulting applications - TSR
- How to: Subscribe all users to a page (Framework 6.1) - TSR
- How to check if Full Text Indexing is installed on SQL Server
- Password Reset for Employee Role every 90 days
- Getting a list of locked Database Documents from SQL
- How To: Export a list of all users within the Portal
- Retrieving the list of URL links from the portal. - TSR
- Creating a SQL task to rebuild portal indexes
- Getting Role Permissions from the portal in a SQL Report
- Exporting a Database Document List from the portal - TSR
- How To: Backup All Databases at Once
- How to Copy One User's Alerts Out to ALL Users.
- How to see what SQL process is slowing down the server
- Login failed for user ''. The user is not associated with a trusted SQL Server connection.
- Removing everyone's permissions to delete Pages
- All PFW - Moving Database Files to New Location on Server
- How To: Migrate Databases to Another SQL Server
- SQL Maintenance - Reduce Size of SQL .ldf Files
- Daily Change History Report From Vendor
- Locating Document IDs and Removing/Adding Permissions, by script