SQL
Scripts, maintenance plans, queries, and more!
- Getting information about your LMS courses from SQL
- Setting all alerts for primary consulting applications
- How to: Subscribe all users to a page (Framework 6.1)
- 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
- Migrating Knowledge Management Documents from KM to Database Documents
- Migrating island arrangement information from one SQL database to another.
- Retrieving the list of URL links from the portal.
- SQL - Adding permissions to assistant managers for the new 5.0 islands
- How To: Reset island sizes after updating to 5.0 +
- Creating a SQL task to rebuild portal indexes
- Getting Role Permissions from the portal in SQL.
- Exporting a Database Document List from the portal
- How To: Backup All Databases at Once
- Adding all users as Assistant Admins of a workgroup with permissions to edit Portal Text Editors
- How to Copy One User's Alerts Out to ALL Users.
- SQL Queries cause the portal to run slowly
- 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
- Get a List of Roles and Role Members from SQL
- How to get list of fields, including custom fields, from Portal Framework
- 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
- Archive: PFW 4.11.1- Documents Throw HTTP 401.3 Authentication Error
- Daily Change History Report From Vendor
- Locating Document IDs and Removing/Adding Permissions, by script