# Toad for SQL Server

**URL:** https://forums.toadworld.com/c/toad-for-sql-server/11.md

[Latest](https://forums.toadworld.com/latest.md) · [Categories](https://forums.toadworld.com/categories.md)

---

## [How to get the most out of this forum – a post describing best practices for what information to include:](https://forums.toadworld.com/t/how-to-get-the-most-out-of-this-forum-a-post-describing-best-practices-for-what-information-to-include/38438)

<div class="topic-metadata">

**Author:** [@Chad.Ossiginac](https://forums.toadworld.com/u/Chad.Ossiginac)\
**Replies:** 0\
**Last updated:** [August 1, 2024, 7:00am UTC](https://forums.toadworld.com/t/how-to-get-the-most-out-of-this-forum-a-post-describing-best-practices-for-what-information-to-include/38438 "2024-08-01T07:00:00Z")

</div>

The better a problem is described, the better the assistance tends to be. In order to better assist with your issue at hand, please include the following information in your initial post: Product, Version, and releva…

---

## [Provide a Secure Alternative to the Deprecated Log Reader Feature Without Server-Side Component Installation](https://forums.toadworld.com/t/provide-a-secure-alternative-to-the-deprecated-log-reader-feature-without-server-side-component-installation/61847)

<div class="topic-metadata">

**Author:** [@nikola.petrovic](https://forums.toadworld.com/u/nikola.petrovic)\
**Replies:** 1\
**Last updated:** [September 23, 2026, 8:27pm UTC](https://forums.toadworld.com/t/provide-a-secure-alternative-to-the-deprecated-log-reader-feature-without-server-side-component-installation/61847 "2026-09-23T20:27:54Z")

</div>

The Log Reader feature was available in previous versions of Toad for SQL Server but has been removed from the current 2026 R2 release. A request has been raised to provide an alternative solution for transaction log ana…

---

## [Adding Column Descriptions to Views vs Tables is not Consistent](https://forums.toadworld.com/t/adding-column-descriptions-to-views-vs-tables-is-not-consistent/61809)

<div class="topic-metadata">

**Author:** [@michael.r.hinkle](https://forums.toadworld.com/u/michael.r.hinkle)\
**Replies:** 1\
**Last updated:** [August 24, 2026, 8:37pm UTC](https://forums.toadworld.com/t/adding-column-descriptions-to-views-vs-tables-is-not-consistent/61809 "2026-08-24T20:37:00Z")

</div>

When looking at the Column tab for a View and clicking on a Description, the Edit Description option appears in the header or right clicking on the Description allows for selecting MS\_Description from the dropdown as se…

---

## [Toad for SQL Server Freeware Updated (6.8.2)](https://forums.toadworld.com/t/toad-for-sql-server-freeware-updated-6-8-2/41259)

<div class="topic-metadata">

**Author:** [@Nate.Gaffaney](https://forums.toadworld.com/u/Nate.Gaffaney)\
**Replies:** 12\
**Last updated:** [July 29, 2026, 1:13pm UTC](https://forums.toadworld.com/t/toad-for-sql-server-freeware-updated-6-8-2/41259 "2026-07-29T13:13:46Z")

</div>

Toad for SQL Server Freeware 6.8.2 is available for download in both 64-bit and 32-bit from the Toad World Downloads page. Specific link: https://www.toadworld.com/download/toad-for-sql-server/freeware This should reso…

---

## [Alter Table not seeing Changes](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740)

<div class="topic-metadata">

**Author:** [@michael.r.hinkle](https://forums.toadworld.com/u/michael.r.hinkle)\
**Replies:** 6\
**Last updated:** [July 21, 2026, 3:49pm UTC](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740 "2026-07-21T15:49:41Z")

</div>

I just went into Alter Table to change the length of an nvarchar column. I made the change to the length in the GUI, then went to the SQL Script tab and get the "-- No Changes Detected" message. I manually wrote …

---

## [Tools menu option is missing](https://forums.toadworld.com/t/tools-menu-option-is-missing/61746)

<div class="topic-metadata">

**Author:** [@italbe45](https://forums.toadworld.com/u/italbe45)\
**Replies:** 4\
**Last updated:** [July 13, 2026, 7:50pm UTC](https://forums.toadworld.com/t/tools-menu-option-is-missing/61746 "2026-07-13T19:50:24Z")

</div>

My Tools menu option is missing from my Toad for SQL server 2026 R2 application. How do I get it back? Thank you for any help.

---

## [Can't Exit The Application](https://forums.toadworld.com/t/cant-exit-the-application/61734)

<div class="topic-metadata">

**Author:** [@italbe45](https://forums.toadworld.com/u/italbe45)\
**Replies:** 3\
**Last updated:** [July 9, 2026, 12:29pm UTC](https://forums.toadworld.com/t/cant-exit-the-application/61734 "2026-07-09T12:29:14Z")

</div>

I am running Toad for SQL Server 2026 R2 on my windows 11 pro laptop for about a month now (after upgrading from R1). Starting this week the application will not shut down by either clicking the red X button in the uppe…

---

## [Toad for SQL Server Beta Program](https://forums.toadworld.com/t/toad-for-sql-server-beta-program/61741)

<div class="topic-metadata">

**Author:** [@michael.r.hinkle](https://forums.toadworld.com/u/michael.r.hinkle)\
**Replies:** 1\
**Last updated:** [July 6, 2026, 8:39pm UTC](https://forums.toadworld.com/t/toad-for-sql-server-beta-program/61741 "2026-07-06T20:39:15Z")

</div>

Is there a Beta program for Toad for SQL Server? I have participated in the Beta program for Toad for Oracle for years and found it to be extremely useful. Thanks, Michael

---

## [LEAST and GREATEST not recognized/highlighted in Editor](https://forums.toadworld.com/t/least-and-greatest-not-recognized-highlighted-in-editor/61735)

<div class="topic-metadata">

**Author:** [@michael.r.hinkle](https://forums.toadworld.com/u/michael.r.hinkle)\
**Replies:** 0\
**Last updated:** [July 2, 2026, 1:26pm UTC](https://forums.toadworld.com/t/least-and-greatest-not-recognized-highlighted-in-editor/61735 "2026-07-02T13:26:00Z")

</div>

SQL Server supports LEAST and GREATEST functions since 2022. They appear to be missing from the internal highlighting dictionary as they do not get treated as built-in functions:

---

## [Transaction log reader issue](https://forums.toadworld.com/t/transaction-log-reader-issue/61721)

<div class="topic-metadata">

**Author:** [@shaimaa](https://forums.toadworld.com/u/shaimaa)\
**Replies:** 1\
**Last updated:** [July 2, 2026, 9:49am UTC](https://forums.toadworld.com/t/transaction-log-reader-issue/61721 "2026-07-02T09:49:18Z")

</div>

we can read transaction log small size successfully but failed to read transaction log big size 337 M . Is there anyone face this issue before ? Thanks

---

## [Toad for SQL Server Add Support for Registered Server Groups (SSMS-style)](https://forums.toadworld.com/t/toad-for-sql-server-add-support-for-registered-server-groups-ssms-style/61717)

<div class="topic-metadata">

**Author:** [@carlos.ortiz](https://forums.toadworld.com/u/carlos.ortiz)\
**Replies:** 1\
**Last updated:** [July 2, 2026, 9:23am UTC](https://forums.toadworld.com/t/toad-for-sql-server-add-support-for-registered-server-groups-ssms-style/61717 "2026-07-02T09:23:21Z")

</div>

Enhancement Request Summary: Several customers, including PNC Bank, have requested functionality similar to SQL Server Management Studio (SSMS) Registered Servers, allowing users to organize and manage SQL Server connec…

---

## [Bug in the Object Details export](https://forums.toadworld.com/t/bug-in-the-object-details-export/61727)

<div class="topic-metadata">

**Author:** [@bog](https://forums.toadworld.com/u/bog)\
**Replies:** 1\
**Last updated:** [June 22, 2026, 6:55pm UTC](https://forums.toadworld.com/t/bug-in-the-object-details-export/61727 "2026-06-22T18:55:50Z")

</div>

Hello Toad for Sql server support, I would like to report a bug. I clicked on a table in the Object Explorer to view its details in the Object Details window (this window was docked on the right side of the app window) …

---

## [SQLServer 2026 R1 keeps asking me to install SQL Optimizer](https://forums.toadworld.com/t/sqlserver-2026-r1-keeps-asking-me-to-install-sql-optimizer/61651)

<div class="topic-metadata">

**Author:** [@italbe45](https://forums.toadworld.com/u/italbe45)\
**Replies:** 2\
**Last updated:** [June 9, 2026, 12:29pm UTC](https://forums.toadworld.com/t/sqlserver-2026-r1-keeps-asking-me-to-install-sql-optimizer/61651 "2026-06-09T12:29:07Z")

</div>

I just installed SQL Server 2026 R1 (fresh install) and the SQL Optimizer for SQL Server on my windows 11 pro laptop, but Toad keeps saying I have additional software to install and would I like to install it now every t…

---

## [Data compare issue?](https://forums.toadworld.com/t/data-compare-issue/61698)

<div class="topic-metadata">

**Author:** [@bog](https://forums.toadworld.com/u/bog)\
**Replies:** 3\
**Last updated:** [June 2, 2026, 9:56pm UTC](https://forums.toadworld.com/t/data-compare-issue/61698 "2026-06-02T21:56:03Z")

</div>

Hello, I am using Toad for SQL Server 8.0.0.65 (64 bit). I have a table with the same name in 2 databases. The 2 tables don't have exactly the same structure but they have 2 fields in common, the primary key and anothe…

---

## [View Column Descriptions not Appearing in Script Tab](https://forums.toadworld.com/t/view-column-descriptions-not-appearing-in-script-tab/61692)

<div class="topic-metadata">

**Author:** [@michael.r.hinkle](https://forums.toadworld.com/u/michael.r.hinkle)\
**Replies:** 2\
**Last updated:** [June 2, 2026, 11:09am UTC](https://forums.toadworld.com/t/view-column-descriptions-not-appearing-in-script-tab/61692 "2026-06-02T11:09:39Z")

</div>

When on the Script tab for a table and you click the Extended Properties checkbox the script shown will include all the column comments added to the table like shown here: However when looking at the script for a Vie…

---

## [Toad for SQL Server 2026 R2 – General Availability Announcement](https://forums.toadworld.com/t/toad-for-sql-server-2026-r2-general-availability-announcement/61701)

<div class="topic-metadata">

**Author:** [@rejhan.kuc](https://forums.toadworld.com/u/rejhan.kuc)\
**Replies:** 0\
**Last updated:** [June 1, 2026, 4:05pm UTC](https://forums.toadworld.com/t/toad-for-sql-server-2026-r2-general-availability-announcement/61701 "2026-06-01T16:05:34Z")

</div>

Hi everyone, We’re excited to share that Toad for SQL Server 2026 R2 is now officially GA! This release introduces Toad Chat, a new AI-powered conversational assistant designed to help users work more efficiently with …

---

## [Disappointed big time with Toad for Sql server](https://forums.toadworld.com/t/disappointed-big-time-with-toad-for-sql-server/11973)

<div class="topic-metadata">

**Author:** [@costab](https://forums.toadworld.com/u/costab)\
**Replies:** 25\
**Last updated:** [May 28, 2026, 12:29pm UTC](https://forums.toadworld.com/t/disappointed-big-time-with-toad-for-sql-server/11973 "2026-05-28T12:29:27Z")

</div>

I used Toad for Oracle in the past and I thought Toad for SQL Server has the same kind of quality hence I bought a license. Big disappointment! Right now I cannot recommend it to anybody. For a 700$ tool I cannot event …

---

## [Toad for SQL Server 2026 R1 – General Availability Announcement](https://forums.toadworld.com/t/toad-for-sql-server-2026-r1-general-availability-announcement/61634)

<div class="topic-metadata">

**Author:** [@rejhan.kuc](https://forums.toadworld.com/u/rejhan.kuc)\
**Replies:** 0\
**Last updated:** [April 1, 2026, 3:51pm UTC](https://forums.toadworld.com/t/toad-for-sql-server-2026-r1-general-availability-announcement/61634 "2026-04-01T15:51:32Z")

</div>

Hi everyone, We’re excited to share that Toad for SQL Server 2026 R1 is now officially GA! This release focuses on simplifying deployment and licensing, introducing a more flexible subscription experience and a unified…

---

## [Schema Compare in 4.6, 5.0 and 5.5](https://forums.toadworld.com/t/schema-compare-in-4-6-5-0-and-5-5/14643)

<div class="topic-metadata">

**Author:** [@JFischer\_484](https://forums.toadworld.com/u/JFischer_484)\
**Replies:** 12\
**Last updated:** [March 24, 2026, 12:20pm UTC](https://forums.toadworld.com/t/schema-compare-in-4-6-5-0-and-5-5/14643 "2026-03-24T12:20:15Z")

</div>

I have mentioned this before (to product support), and some small changes have, happily, been made. However, I recently went into schema compare in TOAD 5.5 (accidentally), and had a severe allergic reaction. Why oh wh…

---

## [Toad Data Point VS Toad for SQL Server](https://forums.toadworld.com/t/toad-data-point-vs-toad-for-sql-server/38974)

<div class="topic-metadata">

**Author:** [@netanel](https://forums.toadworld.com/u/netanel)\
**Replies:** 2\
**Last updated:** [March 24, 2026, 12:16pm UTC](https://forums.toadworld.com/t/toad-data-point-vs-toad-for-sql-server/38974 "2026-03-24T12:16:42Z")

</div>

Hello, I am looking for a tool that i can manage my SQL Server easily. I can see that there is 2 tools that look the same: Toad for Data Point 2)Toad for SQL Server What are you reccomnded? And what are the diffre…

---

## [Subscription-based Toad product and DuckDuckGo browser](https://forums.toadworld.com/t/subscription-based-toad-product-and-duckduckgo-browser/61476)

<div class="topic-metadata">

**Author:** [@nodier.garcia](https://forums.toadworld.com/u/nodier.garcia)\
**Replies:** 0\
**Last updated:** [December 18, 2025, 9:45pm UTC](https://forums.toadworld.com/t/subscription-based-toad-product-and-duckduckgo-browser/61476 "2025-12-18T21:45:41Z")

</div>

Currently, if your default browser is DuckDuckGo and you try to use any Toad product with a subscription-based license, the tool will not load the login webpage to validate the license. This idea is to have the tools su…

---

## [Data/Schema compare synch scripts should add PRINT statements in their script](https://forums.toadworld.com/t/data-schema-compare-synch-scripts-should-add-print-statements-in-their-script/61475)

<div class="topic-metadata">

**Author:** [@armando.reyes](https://forums.toadworld.com/u/armando.reyes)\
**Replies:** 0\
**Last updated:** [December 17, 2025, 12:30am UTC](https://forums.toadworld.com/t/data-schema-compare-synch-scripts-should-add-print-statements-in-their-script/61475 "2025-12-17T00:30:27Z")

</div>

Other competitor tools generate descriptive lines of code when creating a comparison script. for instance: /\*Altering object\*/ PRINT 'Altering object obj1.View’ ALTER View \\\[obj1\\\].\\\[dbo\\\] as Select a as all… So when…

---

## [Is it possible to group SQL Jobs by SQL Job Category?](https://forums.toadworld.com/t/is-it-possible-to-group-sql-jobs-by-sql-job-category/61374)

<div class="topic-metadata">

**Author:** [@bog](https://forums.toadworld.com/u/bog)\
**Replies:** 0\
**Last updated:** [October 7, 2025, 4:52pm UTC](https://forums.toadworld.com/t/is-it-possible-to-group-sql-jobs-by-sql-job-category/61374 "2025-10-07T16:52:24Z")

</div>

Hello, Is it possible to configure TSS to show the jobs grouped by Job Category. I use the tree view and it would be awesome if I could somehow to tell TSS to display the Job Categories as nodes in the tree and the SQL…

---

## [Toad for SQL Server 8.1 is released!](https://forums.toadworld.com/t/toad-for-sql-server-8-1-is-released/59761)

<div class="topic-metadata">

**Author:** [@rejhan.kuc](https://forums.toadworld.com/u/rejhan.kuc)\
**Replies:** 8\
**Last updated:** [October 3, 2025, 10:05am UTC](https://forums.toadworld.com/t/toad-for-sql-server-8-1-is-released/59761 "2025-10-03T10:05:41Z")

</div>

Hi everyone, we released Toad for SQL Server v8.1 earlier this week. Below are a few of the enhancements included in this release. Besides these enhancements, we have added 4 of the ApexSQL products to the Toad for SQL S…

---

## [Real-Time Query Duration Display While Executing in TOAD for SQL Server](https://forums.toadworld.com/t/real-time-query-duration-display-while-executing-in-toad-for-sql-server/61239)

<div class="topic-metadata">

**Author:** [@akulpa](https://forums.toadworld.com/u/akulpa)\
**Replies:** 2\
**Last updated:** [September 26, 2025, 8:00pm UTC](https://forums.toadworld.com/t/real-time-query-duration-display-while-executing-in-toad-for-sql-server/61239 "2025-09-26T20:00:10Z")

</div>

I frequently run long and complex queries in TOAD for SQL Server. Currently, TOAD only displays the execution duration after the query completes. It would be extremely helpful to have a real-time display of query duratio…

---

## [Data Compare Drop/Create primary keys and unique contraints option](https://forums.toadworld.com/t/data-compare-drop-create-primary-keys-and-unique-contraints-option/38393)

<div class="topic-metadata">

**Author:** [@ckoptides](https://forums.toadworld.com/u/ckoptides)\
**Replies:** 11\
**Last updated:** [September 26, 2025, 8:08am UTC](https://forums.toadworld.com/t/data-compare-drop-create-primary-keys-and-unique-contraints-option/38393 "2025-09-26T08:08:47Z")

</div>

Hi, We are using the trial version V6.7.0.176 and we have encountered an issue with the generated script when we perform data compare between two databases. If we select the “Drop/Create primary keys and unique constra…

---

## [Feature Request - Please improve column hints from CTE's and synonyms](https://forums.toadworld.com/t/feature-request-please-improve-column-hints-from-ctes-and-synonyms/61354)

<div class="topic-metadata">

**Author:** [@mparker](https://forums.toadworld.com/u/mparker)\
**Replies:** 0\
**Last updated:** [September 25, 2025, 6:48pm UTC](https://forums.toadworld.com/t/feature-request-please-improve-column-hints-from-ctes-and-synonyms/61354 "2025-09-25T18:48:09Z")

</div>

As a former user of ApexSQL Complete, please improve column hints from CTE's and synonyms. It is a feature that I really miss from Complete. If there is already a setting that allows hints for CTE's and/or synonyms, plea…

---

## [Feature Request: Allow linked server columns to be included in the hints](https://forums.toadworld.com/t/feature-request-allow-linked-server-columns-to-be-included-in-the-hints/61358)

<div class="topic-metadata">

**Author:** [@mparker](https://forums.toadworld.com/u/mparker)\
**Replies:** 0\
**Last updated:** [September 25, 2025, 7:26pm UTC](https://forums.toadworld.com/t/feature-request-allow-linked-server-columns-to-be-included-in-the-hints/61358 "2025-09-25T19:26:25Z")

</div>

Can you look into the possibility of adding this functionality as an option? I realize not everyone may want this as it may slow down the hints.

---

## [Feature Request: Allow snippets to be included in the hints](https://forums.toadworld.com/t/feature-request-allow-snippets-to-be-included-in-the-hints/61357)

<div class="topic-metadata">

**Author:** [@mparker](https://forums.toadworld.com/u/mparker)\
**Replies:** 0\
**Last updated:** [September 25, 2025, 7:09pm UTC](https://forums.toadworld.com/t/feature-request-allow-snippets-to-be-included-in-the-hints/61357 "2025-09-25T19:09:37Z")

</div>

As a former ApexSQL user, I miss that our snippets are not included in hints. Can you look into the possibility of adding this funtionality?

---

## [GUI Bug: Full Expand And Collapse Snippet Folders Is Non-Functional](https://forums.toadworld.com/t/gui-bug-full-expand-and-collapse-snippet-folders-is-non-functional/61356)

<div class="topic-metadata">

**Author:** [@mparker](https://forums.toadworld.com/u/mparker)\
**Replies:** 0\
**Last updated:** [September 25, 2025, 7:01pm UTC](https://forums.toadworld.com/t/gui-bug-full-expand-and-collapse-snippet-folders-is-non-functional/61356 "2025-09-25T19:01:47Z")

</div>

I am able to see the Full Expand and Full Collapse options when right-clicking any snippet folder, but as soon as I move my cursor to select an option the GUI changes to the standard snippet right-click menu. This appear…

[Next page](https://forums.toadworld.com/c/toad-for-sql-server/11.md?page=1)
