Repository navigation
Releases
Releases · jamtheradar/SQLExtended
SQLExtended 2026.11.9.936
DataByte for SSMS 2026.11.9.936
New
- Replication monitor: click a subscription, agent or error to open a detail pane under the tabs. It shows the full error (every message SQL Server logged for the failure, not just the first line), the agent's recent history, and the command the distribution agent stopped on, with the row's values and the source and destination tables. That is usually enough to see which value broke it. Copy details copies it all as text, and Open as query opens the T-SQL behind it. Nothing loads until you click, and nothing is written to the server.
Fixed
- Replication monitor: Load recent errors failed with "Input string was not in a correct format" when an error code contained letters (such as MSSQL_REPL20011), so the Errors tab never loaded.
SQLExtended 2026.11.6.1357
DataByte for SSMS 2026.11.6.1357
New
- ScriptCast (SQLExtended > ScriptCast). Run the query window's script, or its selection, on many databases at once, across every server connected in Object Explorer. Tick the databases (with Select All, a name filter and a hide-system-databases option), click Cast, and each database runs in parallel on its own connection. The results merge into one grid per result set with ServerName and DatabaseName first; a database whose columns don't match gets its own flagged tab. Each database's messages, errors and rows affected are shown, with a summary.
GObatches work as they do in a query window. Thanks to @walterstypula for the idea and the detailed spec (#13). - Cast Lists. Save the ticked databases as a plain JSON file, load one (a network share works, so a team can share them), and open it in an SSMS tab to edit by hand; saving reloads it. A bad entry is flagged without stopping the rest of the list loading, servers that aren't connected show with a Connect button, and a Cast List never holds credentials.
- ScriptCast transaction mode. Tick Run in transaction and each database's changes stay uncommitted until you click Commit All (enabled only when every database succeeded) or Rollback All. Rows affected per database are shown before you commit. With Auto rollback (on by default), one failure rolls back every database. Open transactions roll back by themselves after a timeout (300 seconds by default, Settings > ScriptCast, or change it for one cast). Scripts with their own BEGIN TRAN, COMMIT or ROLLBACK are refused in this mode. Commits run one database after another, so if a connection drops partway through, the Summary says exactly which databases committed.
- ScriptCast asks before running a script that changes data or schema when Select All was used, and applies the UPDATE/DELETE-without-WHERE check to every cast.
- Schema Compare (SQLExtended > Schema Compare). Compare two schemas side by side: folder exports, database projects or live databases. Choose what to ignore, see each object's differences, and generate a change script.
Fixed
- IntelliSense: Space could replace a word you had already finished with a suggestion that only contained it, so
DELETE FROMfollowed by Space becameDELETE DATEFROMPARTS. Space now only accepts a suggestion that starts with what you typed, and never replaces a complete keyword such asIS,INorAS. Thanks to @walterstypula for the report (#11).
SQLExtended 2026.11.1.1915
Build 2026.11.1.1915
SQLExtended 2026.10.27.858
DataByte for SSMS 2026.10.27.858
New
- Copy as IN Filter. Select cells in one column of a results grid and press Ctrl+Shift+I (or right-click the grid and choose Copy as IN Filter) to copy them as an
IN (...)list, one value per line. Text, dates and GUIDs are quoted and numbers are not, going by the column's type, so a varchar007stays'007'. Quotes inside values are escaped and NULLs are left out. The item is greyed out when the selection covers more than one column. Thanks to @walterstypula for the suggestion (#5). - Open Definition. Press F12 on a table, view, procedure, function or trigger name to open its script in a new query window connected to the same server and database. Procedures, functions, views and triggers come out as CREATE OR ALTER; you can pick CREATE or ALTER instead under Settings → Search → Open Definition. The View Schema window also has an Open in Script Window button. Thanks to @walterstypula for the suggestion (#6).
- Locate in Object Explorer. Press Ctrl+F12 on an object name to expand Object Explorer to it, select it and move to it. If the server isn't connected in Object Explorer yet, it connects it with the query window's own login. Triggers are found under their table, and system databases work too. Thanks to @walterstypula for the suggestion (#7).
- Align On. Select some lines (or put the cursor in a block) and press Ctrl+= to line up AS, ON, =, --, commas, THEN or any word you type. Press Enter to align the first one on each line, or Shift+Enter to align every one. Words inside strings, comments and brackets are ignored. Press Ctrl+= again to align on the next word, since the lines stay selected. Thanks to @walterstypula for the suggestion (#8).
- Format Selection. Press Ctrl+K, Ctrl+Shift+F to format only the statements the selection touches, or the one the cursor is in. The rest of the script is left exactly as it was, and the formatted statement keeps its indent, so a SELECT inside a procedure stays where it is. Format SQL is unchanged (#8).
- Format With. Choose SQLExtended → Format With (or right-click) to pick which rules to apply this time: keyword case, function name case, removing brackets that aren't needed, LEFT OUTER JOIN → LEFT JOIN, adding semicolons, tabs or spaces, trimming trailing spaces, or the full format. Save a choice as a named preset; "Casing only" and "Full format" are there to start with. The first five presets can be given their own shortcuts under Tools → Options → Keyboard (search for FormatPreset) (#8).
- Uppercase Keywords (Ctrl+B, Ctrl+U), Remove Brackets (Ctrl+B, Ctrl+B) and Insert Semicolons (Ctrl+B, Ctrl+C) each do one job without changing the layout.
Changed
- Shortcuts now match Redgate SQL Prompt wherever SQLExtended has the same command, so they will be familiar if you have used it. Format SQL is now Ctrl+K, Ctrl+Y (it was Ctrl+K, Ctrl+F and Ctrl+K, Ctrl+Q), and Qualify Columns is now Ctrl+B, Ctrl+Q (it was Ctrl+K, Ctrl+A). The old shortcuts no longer run these commands; if you want them back, set them under Tools → Options → Keyboard.
- In a query window, Ctrl+Shift+I now runs Copy as IN Filter instead of the editor's reverse incremental search.
Fixed
- View Schema now finds a procedure, function or trigger named without its schema (such as
usp_GetOrdersinEXEC usp_GetOrders). Before, only tables and views were found that way.
SQLExtended 2026.10.27.1019
DataByte for SSMS 2026.10.27.1019
New
- Match whole word in SQL Search. Tick the box beside the search box (Ctrl+Alt+F) to find the term only as a whole name or word:
personfindsperson,dbo.person,[person]andWHERE person = 1, but notpersonal,PersonAddress,person_id,@personor#person. It applies to names, columns, definitions and Agent jobs, and the preview highlights only those matches. The box remembers its setting between sessions. Thanks to @RalphNehme for the suggestion (#9).
Fixed
- In SQL Search, a search containing
_(as most column names do) treated it as "any character" when searching definitions, so it could return objects that didn't contain the term. A%did the same. - Find References missed objects whose own name contained the term. For example, asking what uses
Personleft out a view calledvPersoneven though its definition usedPerson.
SQLExtended 2026.10.23.1755
DataByte for SSMS 2026.10.23.1755
New
- Tab after SELECT * expands it. With the cursor straight after a
*oralias.*in a SELECT list, press Tab and the star is replaced with the column list, each column prefixed with its table's alias; a table without an alias is given one. The columns are laid out using the formatter's column and comma settings. It needs the schema cache loaded for the database, andCOUNT(*)is never touched. Switch it off under Settings → IntelliSense. Thanks to @walterstypula for the suggestion (#4). - A SQLExtended submenu on the query editor's right-click menu, with View Schema, Format SQL, Qualify Columns, Parse Statistics, SQL Search, SQL History, Script Library, Validate Schema References, the schema cache commands and the settings. Parse Statistics is also on the Messages pane's right-click menu.
- The SQLExtended menu now shows each command's keyboard shortcut beside it.
Changed
- Qualify Columns is now Ctrl+K, Ctrl+A (it was Ctrl+K, Ctrl+Q). Ctrl+K, Ctrl+Q now runs Format SQL in a query window, the same chord SSMS's own formatter uses, and Ctrl+K, Ctrl+F still works too.
- Replication Monitor no longer has a shortcut: Ctrl+Alt+R belongs to Copilot. Open it from the SQLExtended menu or a server's right-click menu in Object Explorer.
- Settings → Keyboard Shortcuts now lists every command and reads its shortcut from SSMS, so a shortcut you reassign under Tools → Options → Keyboard shows there. Commands without a shortcut show "—".
Fixed
- Qualify Columns and Go to Column were missing from the SQLExtended menu and could only be reached by their shortcuts.
- In a query window, Ctrl+K, Ctrl+F ran SSMS's Format Selection instead of Format SQL, and Ctrl+Alt+F opened Copilot instead of SQL Search. Both now run SQLExtended's commands in a query window.
- SQLExtended's items on the query editor's right-click menu never appeared.
SQLExtended 2026.10.22.1227
DataByte for SSMS 2026.10.22.1227
New
- Qualify Columns. Press Ctrl+K, Ctrl+Q (or right-click in the query editor and choose Qualify Columns) to give every table in a SELECT an alias and put that alias in front of each of its columns:
SELECT FName, City FROM Person JOIN Address ON Person.AddressId = Address.AddressIdbecomesSELECT p.FName, a.City FROM Person p JOIN Address a ON p.AddressId = a.AddressId. It works on the selection, or the whole script when nothing is selected, and one Ctrl+Z undoes it. Aliases you have already written are kept, the new ones are the same initials IntelliSense uses, and qualifiers that name a table by its own name (Person.AddressId,dbo.Person.*) switch to the alias. Which table a column belongs to comes from the schema cache, and a column is only prefixed when exactly one table has it: a column found in more than one table, one that is not found (such as a select-list alias in ORDER BY), or one in a query that also reads from something whose columns are not known (OPENJSON, PIVOT, a table not in the cache) is left as written, and the status bar says how many were. Subqueries, CTEs, derived tables, CROSS APPLY, temp tables and table variables are handled; the table an UPDATE, DELETE, MERGE or INSERT writes to is not aliased, but the SELECTs inside those statements are. Your layout and comments are left as they were. If the schema cache for the database has not loaded yet, it starts loading and asks you to try again. Thanks to @walterstypula for the suggestion (#3).
SQLExtended 2026.10.19.1637
DataByte for SSMS 2026.10.19.1637
New
- Go to Column in the results grid. With many columns returned, press Ctrl+Alt+K (or right-click the grid and choose Go to Column…) and type part of a column name: the list narrows as you type, best match first. Exact names come first, then names that start with what you typed, then a word inside the name (
qtyfinds Ongoing_Qty and OngoingQty), then anywhere in the name, then initials (oqdfinds OngoingQtyDate). Each column shows its data type and its position on screen, so two columns with the same name from a join can be told apart. Up and Down move through the list while you keep typing; Enter takes the grid to that column in the row you were on, scrolls it into view and puts the focus back in the grid. With more than one result set, the grid you were in is listed first and the others are labelled Result 2, Result 3 and so on. - IntelliSense: synonyms. A synonym is now offered where the object it points at would be: synonyms for tables and views after FROM and JOIN (with an alias, like a table), synonyms for procedures after EXEC, and synonyms for functions after
dbo.. The list shows what each one points at, and there is a Synonyms filter button. Columns come through the synonym too:FROM dbo.MySynonym s WHERE s.lists the columns of the table behind it, and EXEC parameter expansion works for a procedure synonym. A synonym whose target cannot be read (on a linked server, or in a database you have no access to) is offered after both FROM and EXEC. - IntelliSense: linked servers. Linked server names are offered after FROM, JOIN and EXEC, inside
OPENQUERY(and afterEXEC (…) AT. Settings → IntelliSense → Linked servers chooses how far it goes: Off, Names (the default), Names and databases, or Names, databases, tables and columns. The two higher levels read from the linked server itself, so they wait on that server:LinkedServer.lists its databases,LinkedServer.Sales.its schemas,LinkedServer.Sales.dbo.its tables and views, and an alias on a four-part name lists that table's columns. The first time each of these is asked for, the list comes back empty while it is read; the next time it is there. Procedures on a linked server are not listed. A synonym that points at a linked server gets its columns the same way. - Schema Cache window: a Linked servers branch under each server. It shows each linked server's product and data source, how many databases have been read, and for each database the number of tables, views and synonyms and how many tables have had their columns read. Anything that could not be read shows as failed, with the reason in a tooltip. Right-click to read the list again, or to load or refresh a linked server's databases or a database's tables.
Changed
- The schema cache now records what each synonym points at. Synonyms already in the cache show as "target unknown" until that database is next fully refreshed.
Fixed
- IntelliSense now works while you are part way through a bracketed name that contains a space or a backslash, such as
FROM [My TaorOPENQUERY([SERVER\INST.
SQLExtended 2026.10.15.1506
DataByte for SSMS 2026.10.15.1506
New
- Confirm before an UPDATE or DELETE without a WHERE clause. Executing a query (F5, Ctrl+E or the toolbar's Execute) first checks what is about to run — the selection, or the whole script when nothing is selected — and if any UPDATE or DELETE has no WHERE, lists each one with its line number and asks whether to go ahead. No is the default button, so an Enter pressed out of habit cancels. Not flagged: table variables and #temp tables, a table restricted by an INNER JOIN on it, WHERE CURRENT OF, and statements inside a CREATE or ALTER PROCEDURE, FUNCTION or TRIGGER. DELETE TOP (n) is still flagged, since in a loop it empties the table. A script that does not parse, including a SQLCMD-mode script, is run without the check. On by default; Settings → Editor → Execution safety.
- IntelliSense: an alias for every table picked after FROM or JOIN. Picking Company inserts
dbo.Company c, and that table's columns are then offered asc.ACTIVEeven when it is the only table in the query. The alias is the table's initials, numbered when it would clash with a table or alias already in the statement. It is only added where T-SQL allows one — not after INSERT INTO, UPDATE, DELETE FROM or TRUNCATE TABLE — and not when the name you are replacing already has an alias after it. Table-valued functions do not get one. On by default; Settings → IntelliSense, "Add an alias to tables picked after FROM / JOIN". - IntelliSense: UPDATE template. After
UPDATE dbo.Companythe list offers "(all columns) SET col = val": every column that can be set, each with a placeholder for its type, and a WHERE on the primary key. The key columns are left out of the SET, and so are identity, computed and rowversion columns. A table with no primary key getsWHERE 1 = 0, which updates nothing until you write a real condition. It follows the formatter's indent, comma position and keyword case, like the INSERT templates. - Single quotes close themselves. Typing ' inserts '' with the cursor between them; typing ' again steps over the closing quote, and Backspace on an empty pair removes both. It stays out of the way inside strings (including ones that span lines), comments and bracketed or double-quoted names, and after a word, so O'Brien types normally — except the N of N'…'. On by default; Settings → IntelliSense → Typing, "Close single quotes automatically".
Changed
- Aliases in the foreign-key JOIN suggestions are no longer cut off at four letters: ORDER_LINE_ITEM_TAX_PAYMENT is now olitp rather than olit, so tables that share a prefix get different aliases.
Thanks to Mauricio Miglioranza, who contributed all of the above.
SQLExtended 2026.9.30.1734
DataByte for SSMS 2026.9.30.1734
New
- IntelliSense: column suggestions while writing an index. In
CREATE [UNIQUE] [CLUSTERED | NONCLUSTERED] [COLUMNSTORE] INDEX ix ON dbo.Orders (the list offers the columns of dbo.Orders — in the key list, in theINCLUDE (list, and in a filtered index'sWHERE(at its start and after each AND or OR, where a column can go). A column already named in the key or INCLUDE list is not offered again.CREATE STATISTICS … ON table (works the same way.ONitself now offers table names, including afterON dbo., which used to open an empty column list. - IntelliSense: query hints. Inside
OPTION (the list offers the query hints — RECOMPILE, MAXDOP, OPTIMIZE FOR, OPTIMIZE FOR UNKNOWN, USE HINT, MAXRECURSION, FORCE ORDER, the join and union hints and the rest — each with a one-line description, and again after each comma. InsideUSE HINT (it offers the hint names (DISABLE_PARAMETER_SNIFFING, ENABLE_QUERY_OPTIMIZER_HOTFIXES, the cardinality estimation hints, QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n and others), inserted with their quotes. - IntelliSense: table hints. After a table in FROM, JOIN, UPDATE, DELETE, INSERT INTO or MERGE,
WITH (offers the table hints — NOLOCK, READPAST, UPDLOCK, ROWLOCK, TABLOCK, HOLDLOCK, FORCESEEK, INDEX and the rest. It is not offered after a CTE's WITH or an index's WITH (options), where those hints would not parse. - IntelliSense: index names in index hints.
WITH (INDEX (andWITH (FORCESEEK (list the indexes of the table being hinted, with each index's type and key columns beside it, primary key and clustered index first. An alias works too: inUPDATE o WITH (INDEX (the indexes come from the tableostands for. - Highlight Tab: right-click a document tab and choose Highlight Tab to paint it Rose, Pumpkin, Gold, Volt, Green, Sky or Magenta, so the query you keep coming back to stands out among the rest. The highlight takes precedence over the tab's Environment Tabs colour, works whether or not Environment Tabs is switched on, and lasts until you choose Clear Highlight or close the tab; it is not kept between sessions. Clearing it gives the tab its environment colour back, if it had one.
- Performance Monitor: read and copy the SQL behind a row. Double-click a row in the Activity, Blocking or Top queries grid to open its SQL in a viewer with syntax highlighting — for an active request that is the whole batch with the running statement selected — or right-click for Copy Statement, Copy Batch (Activity only), View Statement and Open in New Query Window. The grids only have room for one collapsed line of each statement.
- Script Library: eight new scripts.
- Monitoring: sp_WhoIsActive by Adam Machanic, in two builds — one for SQL Server 2022 and later, one for 2012 to 2019, which the 2022 build does not compile on — and Rodrigo Nascentes' sp_who3.
- DBA Tools: Microsoft Tiger Team's BPCheck (installs msdb.dbo.usp_bpcheck, a broad best-practice health check) and usp_WhatsUp.
- Security: Failed logins, which summarises the Login failed entries across every error log, and Login info and last login, from Lorenzo Uriel's data-eyes.
- Server Health: Table sizes, the row count and space used by every table in the database, largest first.
The installed procedures are the upstream scripts unchanged, with their copyright and licence headers; sp_WhoIsActive is GPL-3.0 and the rest are MIT. Login info and last login is incomplete upstream (it stops part way through its last statement), so the library copy finishes it, marked with a comment. Credits are in THIRD-PARTY-NOTICES.md.
- IntelliSense: SET options. After
SETthe list offers IDENTITY_INSERT, NOCOUNT, XACT_ABORT, ANSI_NULLS, QUOTED_IDENTIFIER, ARITHABORT, the other session options, STATISTICS IO / TIME / XML / PROFILE and TRANSACTION ISOLATION LEVEL; afterSET TRANSACTION ISOLATION LEVELit offers the five isolation levels.
Changed
- SQL Search: a column result now shows the table it belongs to. The name line reads database . schema . table . column, with the table in bold where every other result shows its object name; before, the column appeared twice and the table only in the small text underneath. The type label says COLUMN · TABLE or COLUMN · VIEW, so columns of views stand out from columns of tables.
- Keyword casing while typing now covers keywords containing an underscore or digit — IDENTITY_INSERT, NOCOUNT, XACT_ABORT, SQL_VARIANT, DATETIME2. They had never been recased. STATISTICS IO, ISOLATION LEVEL and the isolation levels are offered in the list but deliberately not recased as you type, because IO, Level, Read and Snapshot are common column names.
Fixed
- Performance Monitor: the server information panel failed to load on an instance that had written a memory dump. The dump's creation time is a datetimeoffset, which the reader could not convert.
- Keyword casing while typing no longer capitalises columns named Status: STATUS was being treated as a keyword because it is part of @@FETCH_STATUS.
- IntelliSense marked a column (PK) only if it was ascending in the primary key; a column the key sorts descending lost the flag.
- View Schema: a primary key column with a space in its name and a descending sort (
[Order Date] DESC) was read as a column called Order, so the CREATE TABLE script treated it as a non-key column.