# Toad for SQL Server **URL:** https://forums.toadworld.com/c/toad-for-sql-server/11.md?page=2 [Latest](https://forums.toadworld.com/latest.md) · [Categories](https://forums.toadworld.com/categories.md) **Page:** 3 --- ## [Interface Design - Useful](https://forums.toadworld.com/t/interface-design-useful/57750)
**Author:** [@edz](https://forums.toadworld.com/u/edz)\ **Replies:** 1\ **Last updated:** [September 12, 2024, 9:13pm UTC](https://forums.toadworld.com/t/interface-design-useful/57750 "2024-09-12T21:13:50Z")
Would be nice if Toad for SQL Server followed the layout of Toad for Oracle instead configuring like SSMS. Woudl be nice to have a monitor sessions like Toad for Oracle instead of like SSMS Profiler. The object brows… --- ## [BUG: Failed to save the settings for module Editor](https://forums.toadworld.com/t/bug-failed-to-save-the-settings-for-module-editor/47781)
**Author:** [@veskojl](https://forums.toadworld.com/u/veskojl)\ **Replies:** 5\ **Last updated:** [September 2, 2024, 12:44pm UTC](https://forums.toadworld.com/t/bug-failed-to-save-the-settings-for-module-editor/47781 "2024-09-02T12:44:36Z")
Hi, I've just made a fresh installation of Toad For SQL Server v7.0.3.37 on my W10 (Windows 10 Pro 1903 x64 build 18362.356 ) machine and then tried to start the app, but I got the following error (see the att. for a sc… --- ## [Execute Scripts button disabled in the file editor upon creating a new editor](https://forums.toadworld.com/t/execute-scripts-button-disabled-in-the-file-editor-upon-creating-a-new-editor/51696)
**Author:** [@bog](https://forums.toadworld.com/u/bog)\ **Replies:** 4\ **Last updated:** [August 16, 2024, 4:10pm UTC](https://forums.toadworld.com/t/execute-scripts-button-disabled-in-the-file-editor-upon-creating-a-new-editor/51696 "2024-08-16T16:10:30Z")
Hello, I just upgraded to version 7.2.0.233. I noticed that when I created a new sql script editor the Execute Scripts button was disabled by default. I moved back and forth between the tabs and it eventually became ena… --- ## [Explorer filter apply to all records, not just the default loading](https://forums.toadworld.com/t/explorer-filter-apply-to-all-records-not-just-the-default-loading/59691)
**Author:** [@MFeeney](https://forums.toadworld.com/u/MFeeney)\ **Replies:** 2\ **Last updated:** [July 19, 2024, 3:57pm UTC](https://forums.toadworld.com/t/explorer-filter-apply-to-all-records-not-just-the-default-loading/59691 "2024-07-19T15:57:57Z")
Hello, Suggestion: When applying a filter on a column in an Explorer tab, have the filter apply to all records in the table, not just those in the default loading. For example, say there's 22,000 records in a table and… --- ## [Migrate from ApexSQL DataDiff & Script](https://forums.toadworld.com/t/migrate-from-apexsql-datadiff-script/59523)
**Author:** [@ReneL](https://forums.toadworld.com/u/ReneL)\ **Replies:** 1\ **Last updated:** [June 6, 2024, 7:38pm UTC](https://forums.toadworld.com/t/migrate-from-apexsql-datadiff-script/59523 "2024-06-06T19:38:01Z")
I'm totally new to Toad. We currently use ApexSQL DataDiff to generate executable packages of the comparison data and we use ApexSQL Script to generate an executable for creating the database. Can this (or will) this b… --- ## [Execute stored procedure script as a job](https://forums.toadworld.com/t/execute-stored-procedure-script-as-a-job/59442)
**Author:** [@david.o.rogers](https://forums.toadworld.com/u/david.o.rogers)\ **Replies:** 10\ **Last updated:** [May 23, 2024, 6:47pm UTC](https://forums.toadworld.com/t/execute-stored-procedure-script-as-a-job/59442 "2024-05-23T18:47:16Z")
Does this feature work for anyone? When I right-click the stored procedure to alter it, then click on Schedule Job -- I find that I can't schedule the stored procedure as a job. no bueno. --- ## [Can I Export All Return Tables at the Same Time](https://forums.toadworld.com/t/can-i-export-all-return-tables-at-the-same-time/59300)
**Author:** [@tbradley87](https://forums.toadworld.com/u/tbradley87)\ **Replies:** 1\ **Last updated:** [April 26, 2024, 9:24pm UTC](https://forums.toadworld.com/t/can-i-export-all-return-tables-at-the-same-time/59300 "2024-04-26T21:24:39Z")
Hello All, I use Toad for SQL Server at work and we are constantly running the same set of queries and exporting the information so I know how to get the data out. My question here is can I export all of the different … --- ## [Toad for SQL Server - command line interface?](https://forums.toadworld.com/t/toad-for-sql-server-command-line-interface/17049)
**Author:** [@JKG1](https://forums.toadworld.com/u/JKG1)\ **Replies:** 3\ **Last updated:** [April 23, 2024, 2:46pm UTC](https://forums.toadworld.com/t/toad-for-sql-server-command-line-interface/17049 "2024-04-23T14:46:05Z")
Hi, Is it possible to run things like data and schema compare, and schema snapshots, from the command line? Ideally what I’d like to do is automate taking a schema snapshot. I don’t want to use the Automation tools to… --- ## [Need installer of toad sql server 7.4.1](https://forums.toadworld.com/t/need-installer-of-toad-sql-server-7-4-1/59220)
**Author:** [@amraba1t](https://forums.toadworld.com/u/amraba1t)\ **Replies:** 0\ **Last updated:** [April 8, 2024, 3:40pm UTC](https://forums.toadworld.com/t/need-installer-of-toad-sql-server-7-4-1/59220 "2024-04-08T15:40:02Z")
I want to try Toad SQL Server but i need the installer for v7.4.1 I dont want to use the v8.0 Could you please tell me where can i donload toad for sql server 7.4.1 --- ## [Trim (BOTH '"' ... keyword throws an alert when it shouldn't](https://forums.toadworld.com/t/trim-both-keyword-throws-an-alert-when-it-shouldnt/59064)
**Author:** [@armando.reyes](https://forums.toadworld.com/u/armando.reyes)\ **Replies:** 1\ **Last updated:** [April 4, 2024, 6:37pm UTC](https://forums.toadworld.com/t/trim-both-keyword-throws-an-alert-when-it-shouldnt/59064 "2024-04-04T18:37:10Z")
Problem: This query in Toad for SQL Server 8.0 when using trim (BOTH ... keyword: SELECT s.hour , CONVERT(DATETIME2,'01/01/1990 ' + trim(BOTH '"' from s.hour),101) dt1, CONVERT (DATETIME2,'01/02/1990', 101) dt2 FROM… --- ## [Connect to Azure Synapse Analytics SQL Pool](https://forums.toadworld.com/t/connect-to-azure-synapse-analytics-sql-pool/55734)
**Author:** [@osmel.b](https://forums.toadworld.com/u/osmel.b)\ **Replies:** 1\ **Last updated:** [March 27, 2024, 4:45pm UTC](https://forums.toadworld.com/t/connect-to-azure-synapse-analytics-sql-pool/55734 "2024-03-27T16:45:27Z")
When I try to connect to an SQL Pool in Azure Synapse Analytics with TOAD for SQL, the database gives me the error "@@trancount is not supported". Does anyone else have this error? --- ## [Duration display bug](https://forums.toadworld.com/t/duration-display-bug/59021)
**Author:** [@bog](https://forums.toadworld.com/u/bog)\ **Replies:** 5\ **Last updated:** [March 11, 2024, 12:22pm UTC](https://forums.toadworld.com/t/duration-display-bug/59021 "2024-03-11T12:22:18Z")
Hi, In version 8.0.0.65 I noticed the following: I had a query that took over 1 minute to run, then it returned the rows, however, the duration displayed was what you see in the screenshot. I think the duration displaye… --- ## [Linked servers: does not retrieve tables/views of linked server](https://forums.toadworld.com/t/linked-servers-does-not-retrieve-tables-views-of-linked-server/59054)
**Author:** [@jsole](https://forums.toadworld.com/u/jsole)\ **Replies:** 0\ **Last updated:** [March 5, 2024, 10:38am UTC](https://forums.toadworld.com/t/linked-servers-does-not-retrieve-tables-views-of-linked-server/59054 "2024-03-05T10:38:38Z")
Hello, I really don't know if it is feasible now, with Toad for SQL Server Xpert 8.0, but I did not find the option. I have linked an oracle server correctly (and I can query its tables correctly) However, it has not… --- ## [First Experience](https://forums.toadworld.com/t/first-experience/58641)
**Author:** [@waldis](https://forums.toadworld.com/u/waldis)\ **Replies:** 6\ **Last updated:** [February 27, 2024, 5:13pm UTC](https://forums.toadworld.com/t/first-experience/58641 "2024-02-27T17:13:39Z")
Just wanted to share my first experience watching the intro video from the tool. Video as displayed: the story continues with the second screenshot (since we are being limited to only half a sentence per post...) --- ## [Moving position of statusbar objects](https://forums.toadworld.com/t/moving-position-of-statusbar-objects/58954)
**Author:** [@gdailey](https://forums.toadworld.com/u/gdailey)\ **Replies:** 2\ **Last updated:** [February 15, 2024, 9:12pm UTC](https://forums.toadworld.com/t/moving-position-of-statusbar-objects/58954 "2024-02-15T21:12:01Z")
Is there a way to modify where things appear on the statusbar? On version 7.4 of TforSS I have the Autocommit On/Off and the Commit and Rollback icons appearing in the left corner. I'd like to move them at or near the ri… --- ## [Customize placement of Auto-Commit and Commit/Rollback Icons](https://forums.toadworld.com/t/customize-placement-of-auto-commit-and-commit-rollback-icons/58955)
**Author:** [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Replies:** 0\ **Last updated:** [February 15, 2024, 9:01pm UTC](https://forums.toadworld.com/t/customize-placement-of-auto-commit-and-commit-rollback-icons/58955 "2024-02-15T21:01:25Z")
From user gdailey: Is there a way to modify where things appear on the statusbar? On version 7.4 of TforSS I have the Autocommit On/Off and the Commit and Rollback icons appearing in the left corner. I'd like to move th… --- ## [Toad for SQL: Auto complete does not work with DevExpress Dark Skin](https://forums.toadworld.com/t/toad-for-sql-auto-complete-does-not-work-with-devexpress-dark-skin/58851)
**Author:** [@jsole](https://forums.toadworld.com/u/jsole)\ **Replies:** 2\ **Last updated:** [February 12, 2024, 12:27pm UTC](https://forums.toadworld.com/t/toad-for-sql-auto-complete-does-not-work-with-devexpress-dark-skin/58851 "2024-02-12T12:27:16Z")
Hi guys!! It is strange but "auto complete" does not work with the skin "DevExpress Dark Style". Do you know if for that skin I must check something else? When I choose another Skin (default, darkroom for example) it wor… --- ## [8.0 Editor - Highlighting Styles is not saving the selected colour](https://forums.toadworld.com/t/8-0-editor-highlighting-styles-is-not-saving-the-selected-colour/57900)
**Author:** [@chris.waite](https://forums.toadworld.com/u/chris.waite)\ **Replies:** 8\ **Last updated:** [February 12, 2024, 9:51am UTC](https://forums.toadworld.com/t/8-0-editor-highlighting-styles-is-not-saving-the-selected-colour/57900 "2024-02-12T09:51:50Z")
My v8.0 Editor - Highlighting Styles is not saving the selected colour for the display item 'Text' only. All others are okay. I want it white for the dark background but it changes back to black. All Environment - Inter… --- ## [Dat Extraction csv format for all tables](https://forums.toadworld.com/t/dat-extraction-csv-format-for-all-tables/58824)
**Author:** [@gopal.r.pinnamareddy](https://forums.toadworld.com/u/gopal.r.pinnamareddy)\ **Replies:** 2\ **Last updated:** [January 22, 2024, 6:59pm UTC](https://forums.toadworld.com/t/dat-extraction-csv-format-for-all-tables/58824 "2024-01-22T18:59:49Z")
Hello, Looking to extract the csv format for all tables in the sql server. I got the python but not much user friendly .But how do i write power shell or python and debug in side the toad. Or any innovative ideas to e… --- ## [Version 7.4.1.105 64 bit bugs](https://forums.toadworld.com/t/version-7-4-1-105-64-bit-bugs/56871)
**Author:** [@bog](https://forums.toadworld.com/u/bog)\ **Replies:** 4\ **Last updated:** [January 11, 2024, 6:20pm UTC](https://forums.toadworld.com/t/version-7-4-1-105-64-bit-bugs/56871 "2024-01-11T18:20:10Z")
Version 7.4.1.105 64 bit bugs: 'Show in the object explorer' doesn't work anymore! To reproduce: open the editor and select a database, expand it, and also expand the tables node write: select \* from tablename wher… --- ## [The ability to connect to a Single-Tenant Azure App](https://forums.toadworld.com/t/the-ability-to-connect-to-a-single-tenant-azure-app/58742)
**Author:** [@armando.reyes](https://forums.toadworld.com/u/armando.reyes)\ **Replies:** 0\ **Last updated:** [January 2, 2024, 6:37pm UTC](https://forums.toadworld.com/t/the-ability-to-connect-to-a-single-tenant-azure-app/58742 "2024-01-02T18:37:30Z")
When trying to connect to a single-tenant application it throws the error message: "Application '{appId}'({appName}) is not configured as a multi-tenant application. Usage of the /common endpoint is not supported for su… --- ## [How to change "Save Result" setting for Query Builder](https://forums.toadworld.com/t/how-to-change-save-result-setting-for-query-builder/58566)
**Author:** [@hudson](https://forums.toadworld.com/u/hudson)\ **Replies:** 2\ **Last updated:** [November 22, 2023, 7:10pm UTC](https://forums.toadworld.com/t/how-to-change-save-result-setting-for-query-builder/58566 "2023-11-22T19:10:43Z")
Hi-- I turned this option off, a while back, when it appeared prior to saving a .tsm file. I'd like to turn it back on. How do you go back and forth on this. I don't see it in the Tools | Options area. Thank you in ad… --- ## [Lost the database selector in editor menus](https://forums.toadworld.com/t/lost-the-database-selector-in-editor-menus/58355)
**Author:** [@ToadyMan](https://forums.toadworld.com/u/ToadyMan)\ **Replies:** 1\ **Last updated:** [October 23, 2023, 6:23pm UTC](https://forums.toadworld.com/t/lost-the-database-selector-in-editor-menus/58355 "2023-10-23T18:23:56Z")
Hi, I'm fairly new to Toad. Somehow I have lost the database selector at the top of editor windows. And is there a tutorial anywhere on the editor interface/customizing menus? Thanks! --- ## [How many concurrent sessions](https://forums.toadworld.com/t/how-many-concurrent-sessions/58349)
**Author:** [@lewis.schwartz](https://forums.toadworld.com/u/lewis.schwartz)\ **Replies:** 1\ **Last updated:** [October 20, 2023, 5:59pm UTC](https://forums.toadworld.com/t/how-many-concurrent-sessions/58349 "2023-10-20T17:59:49Z")
How many concurrent sessions does TOAD SQL-Server support? I tried running one session on my laptop while one session is running on my remote workstation (office) - I'm using the same install on my workstation. --- ## [ORA-00904: "TYPE": invalid identifier](https://forums.toadworld.com/t/ora-00904-type-invalid-identifier/58335)
**Author:** [@dellantewmekonen](https://forums.toadworld.com/u/dellantewmekonen)\ **Replies:** 1\ **Last updated:** [October 18, 2023, 4:33pm UTC](https://forums.toadworld.com/t/ora-00904-type-invalid-identifier/58335 "2023-10-18T16:33:08Z")
The variable I select contains special character '&' - I even tried to change the character into "AND" then save the updated table on my user schema and try to read and select it again. I am getting the same error. any I… --- ## [SQl optimizer gone in latest version?](https://forums.toadworld.com/t/sql-optimizer-gone-in-latest-version/58265)
**Author:** [@Krashan](https://forums.toadworld.com/u/Krashan)\ **Replies:** 1\ **Last updated:** [October 5, 2023, 3:54pm UTC](https://forums.toadworld.com/t/sql-optimizer-gone-in-latest-version/58265 "2023-10-05T15:54:41Z")
Hi I do not see SQL optimizer in latest package ToadforSQLServer\_Subscription\_8.0.0.65.x64.exe Is it no part of Toad anymore? --- ## [Explorer tabs - stop synching?](https://forums.toadworld.com/t/explorer-tabs-stop-synching/58172)
**Author:** [@MFeeney](https://forums.toadworld.com/u/MFeeney)\ **Replies:** 8\ **Last updated:** [October 5, 2023, 6:32pm UTC](https://forums.toadworld.com/t/explorer-tabs-stop-synching/58172 "2023-10-05T18:32:51Z")
Hello, When using two Explorer tabs (and even the Object Explorer) for the same database, they sync when I change the table filter on any of them. Why is this? I would like to update/insert data in one Explorer (table)… --- ## [Data Compare - how to save results without having to use Synchro Wizard?](https://forums.toadworld.com/t/data-compare-how-to-save-results-without-having-to-use-synchro-wizard/58097)
**Author:** [@FernandoOlmos](https://forums.toadworld.com/u/FernandoOlmos)\ **Replies:** 1\ **Last updated:** [September 20, 2023, 11:08am UTC](https://forums.toadworld.com/t/data-compare-how-to-save-results-without-having-to-use-synchro-wizard/58097 "2023-09-20T11:08:59Z")
The Data Compare feature is fantastic, but unfortunately it is only useful when comparing a few tables at a time. When comparing over 100 tables at once, not only is the resulting Synchro SQL too large to open in Toad (… --- ## [Open the same queries on startup?](https://forums.toadworld.com/t/open-the-same-queries-on-startup/57736)
**Author:** [@twisted9000](https://forums.toadworld.com/u/twisted9000)\ **Replies:** 2\ **Last updated:** [September 5, 2023, 4:42pm UTC](https://forums.toadworld.com/t/open-the-same-queries-on-startup/57736 "2023-09-05T16:42:04Z")
Hello is there anyway to open the same queries on startup? If you can where do I go to do it? Thanks, Chad --- ## [I need a code that will edit a random number](https://forums.toadworld.com/t/i-need-a-code-that-will-edit-a-random-number/58090)
**Author:** [@czboral](https://forums.toadworld.com/u/czboral)\ **Replies:** 0\ **Last updated:** [September 5, 2023, 4:40pm UTC](https://forums.toadworld.com/t/i-need-a-code-that-will-edit-a-random-number/58090 "2023-09-05T16:40:55Z")
I need a code that will do this: If Part# = "124711060301" then Part# = "12471.10.603.01" but for various numbers. The pattern will remain the same - 5digits.2digits.3digits.2digits. I am clearly NOT a programmer but … [Previous page](https://forums.toadworld.com/c/toad-for-sql-server/11.md?page=1) [Next page](https://forums.toadworld.com/c/toad-for-sql-server/11.md?page=3)