Activity overview
Latest activity by rldawg
Dan_J said:
Hi all, The latest version of SQL Search contains some minor improvements (related to the feedback received from this forum thread) to database selections within SQL Search. For example, when choosing a selection of databases to search over, SQL Search will now retain those selections, even if you were to click on a database in Object explorer. @GaryH, I also tested the scenario you DM'd me about. That also appears to have been fixed. The latest version of SQL Search can be downloaded here: https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.13.4316.exeI hope this helps!
Thanks! I'll check it out! / comments
Dan_J said:
Hi all,The latest version of SQL Search contains some minor improvements (related to the feedback received from this forum thread) to database selections within SQL Search.For exa...
SQL Search - Database Selection Reverting to All Databases
I've noticed that when I flip over to another app and flip back to SSMS that the database selector changes from the one DB I have selected to All Databases. Ans so my search results are skewed of ...
Actually I think one of the problems is that when I have open tabs and go to close SSMS, I get this error. I have not transactions in progress. TITLE: Querying transaction count ------------------------------ Unable to query transaction count ------------------------------ ADDITIONAL INFORMATION: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10054-database-engine-error
------------------------------ An existing connection was forcibly closed by the remote host ------------------------------ BUTTONS: OK ------------------------------ / comments
Actually I think one of the problems is that when I have open tabs and go to close SSMS, I get this error. I have not transactions in progress.TITLE: Querying transaction count--------------------...
JR561 said:
Victoria W said:
Hi @rldawg Please can you try disconnecting SQL server from SSMS Object explore, close then open SQL Search, and then reconnect SQL Server?
This worked for me. It was the explicit:
Disconnect from all open database connections
Closed SQL Search (I closed all other Redgate tabs I had pinned too)
Opened SQL Search
Connected to the database
Yeah it seemed that the open tabs caused some kind of issue because SSMS kept beeping at me when I closed it down with the tabs still open (I leave them open knowing SQL prompt will persist them). Normally that's not an issue. But closing them all explicitly, then closing SSMS and re-opening it worked. / comments
JR561 said:
Victoria W said:
Hi @rldawg Please can you try disconnecting SQL server from SSMS Object explore, close then open SQL Search, and then reconnect SQL Server?
This worked ...
SQL Search Greyed Out No controls usanble
For some reason SQL Search is completely disabled. Tried restarting SSMS, Uninstalled Search and reinstalled,. Opened a SQL Query before opening Search. Highlighted a DB before opening Search, ...
Change syntax of Auto-generated Insert Statement
Is there a way in SQL Prompt to change the syntax of the auto-generated INSERT statement to use a SELECT instead of a Values clause?
I am using SQL Server 2012. I am searching all object types that contain the word UPC. / comments
I am using SQL Server 2012. I am searching all object types that contain the word UPC.
Indexing hangs on large database
I am using SQL Search on an Infor SyteLine database. There are hundreds, if not thousands of objects in the database. SQL Search freezes when I try to search for something. It freezes on Indexin...
Ha! Maybe I created it. Sorry, I need to report the bug to myself and fix it!
Although, it's such a good snippet that I thought it was a prepackage one [image]
Another good idea for a snippet called trim:
LTRIM(RTRIM($SELECTEDTEXT$))$CURSOR$
/ comments
Ha! Maybe I created it. Sorry, I need to report the bug to myself and fix it!
Although, it's such a good snippet that I thought it was a prepackage one
Another good idea for a snippet called tr...
Cast as Block Snippet bug - bad comma
The Cast As Block snippet should not have a comma in it.
CAST($SELECTEDTEXT$, AS $CURSOR$)
Corrected:CAST($SELECTEDTEXT$ AS $CURSOR$)