SQL
Scripts, maintenance plans, queries, and more!
- Locating tabbed islands that have tabs with no island on them.
- How to change OnSemble Database new login or password.
- Getting information about your LMS courses from SQL
- Set ALL user profile policies in 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