PKF Smith Cooper Systems

SQL Toolbox

Generate support-safe SQL scripts, copy them to the clipboard, and paste them into SQL Server Management Studio when you are ready.

Configuration DB update

Update tblCompany settings

Updates the SQL instance and attachment UNC path values in tblCompany.

New SQL Instance Stop if SQL instance does not match the current SQL Server

New Attachments Details

Old Server Name New Server Name Drive letter to convert to UNC if required

Search value

Search value type Text Number

Search value

No input is required. The generated script returns all database and table triggers.

No input is required. The generated script returns all stored procedures in the current database.

No input is required. The generated script refreshes each view and reports any failures with the error message.

No input is required. The generated script checks for Sage 50 migration tables before dropping them.

Referenced table name

No input is required. The generated script inserts missing primary key rows into matching dbo X tables and reports inserted or skipped tables.

Generated SQL

Choose a tab, enter any required values, then generate the script.