381 results found
-
trigger order, we need a handy way to set or change trigger order
It is sometimes important to set triggers order when there are several triggers for a single table, UPDATE event, for example.
There is a command which performs this:
EXEC spsettriggerorder @triggername=N'[dbo].[tskTask_Validate]', @order=N'First', @stmttype=N'UPDATE'But I wish I had a visualized tool for this task and more control than a simple 'First' / 'Last' option.
Thank you
1 vote -
Add a link to microsoft help viewer to the help menu
To be able to get the MSD help file / SQL documentation
1 vote -
Default Filter for Database Connection
I have couple of websites and I manage the databases for my website using dbForge Studio by connecting to hosting SQL server. You know that web hostings has hundreds of databases on SQL instance so expanding the connection in database explorer takes time. I wish I was able to embed filters when creating a connection so it will show the selected databases only.
1 vote -
CROSS APPLY for Query Builder
Looks like it is not supported?
Even if enter it manually it is throwing error that no arguments supported.1 vote -
Merge compare script
Can be userfull can have a option in the compare script to can marge the modify of the table structure (add Columns or Modify Columns) in the same query instead have more query. If I have a table with many records if I make more alter very slow instead to make the modify of the structure in 1 single script.
1 vote -
1 vote
-
Database Front End Plugin for Wordpress
I've been trying to find a database front end to use in Wordpress and apart from a very complicated Participants Plugin there is nothing else available, I am building a site for a car club (not for profit) and they want to enter the vehile details and current whereabouts of vehicle that have passed through their club dating back to 1926 so it's available to all their members and members of affiliated clubs wordwide. So that's my suggestion, a Wordpress PLugin.
1 vote -
"Find invalid objects" ... "Select all"
In the "Find invalid objects", I really miss an option to "Select all". There's a "Clear all", but not a "Select all".
1 vote -
Automatically change Collation
I want to automatically change the Collation. If you just change the Collation in the database, then the new Collation applies only to new tables. And old tables need to be changed through a script. The views do not change either.
1 vote -
Search does not find all objects
Search does not find all stored procedures in a case sensitive database. The default case insensitive search misses some objects. To make it work, you must specify the exact case sensitive search string and make the search case sensitive. The default server collation in my instance was case insensitive.
1 vote -
Save breakpoint information when closing a query
If you set a breakpoint, then close the query, when you open the query back up, the previously set breakpoint is no longer present.
1 vote -
Return same data as SSMS Messages tab
In SSMS the number of rows affected by a tsql statement is printed to the Messages tab. In dbForge Studio only the number of rows returned to the application is sent to the Output->General window.
The details in SSMS are extremely useful, especially for UPDATE and DELETE statements or other code that returns no data to the application (e.g. selecting rows into a new table).1 vote -
enable
Window headings are only sql, sql1, sql2 an not the name of the datatable.
1 vote -
the user should be provided the ability to download the results into an excel.
In the "dbForge Search for SQL Server" product, the user should be provided the ability to download the results into excel.
1 vote -
Clean Field Names on Data Import
Most spreadsheets I get have unsupported characters in column headers - like slashes, line breaks and spaces. It would be great to have the import wizard allow a regex or other way to clean up the columns in a batch. e.g. "sales rep" could become "SalesRep", or "district / group" could become "DistrictGroup"
1 vote -
Ignore File Locks on Excel Files During Import
The Excel file should be copied to a temp file to ignore file locks caused by the file being opened in Excel. The import should allow a refresh at the end of the wizard right before the import begins.
1 vote -
remove one condition from filter list
To be able to remove only one filter condition from the grid (list). Not having to clear the filter and start all over again.
1 vote -
Please restore inserting windows into the MRU stack
Prior to the major code change of SQL Studio, when a new window was opened, it always open to the right of the current window. Now, for that past few versions, a new opened window always opens to the right of the Start Page window.
Please restore the open window behavior to place new windows to the top of the Most Recently Used (MRU) window stack. This would be a quality of life improvement, since right now I open a window, then I have to manually move it to where I want it to be.
1 vote -
Add progress when executing script
Show somewhere (the status line at least or perhaps in a new status window) the percentage of commands of a script that has been executed.
1 vote -
auto rename tab with regular expression
would it be possible to add a RegEx search in the script to automatically rename the tabs
"^(\s)(CREATE|ALTER|CREATE\sOR\sALTER)(\s\w\s)((([|)..(]|))|)(([|).(]|))\s*$"
1 vote
- Don't see your idea?