Activity overview
Latest activity by Ben Pinchen
I'm sorry that you're experiencing this issue as SQL Prompt should not be active when you've disabled it. I have seen one other instance of this affecting another user and was able to to partly reproduce this. It is currently logged in our bug tracking software and the developers will be looking into it. They are currently working on SQL Prompt 4 which has had a huge amount of work on it and so I'm hoping that this issue will be resolved. For your reference the bug tracking code is: SP-1380
SQL Prompt 4 is scheduled to be released in Q2 2009, with a beta release due April/May. / comments
I'm sorry that you're experiencing this issue as SQL Prompt should not be active when you've disabled it. I have seen one other instance of this affecting another user and was able to to partly rep...
Thanks for the feedback. I've raised this as a feature request and logged it in the system. The SQL Prompt team will consider adding this extra option in a future version of the application. For your reference the feature request code is: SP-1662 / comments
Thanks for the feedback. I've raised this as a feature request and logged it in the system. The SQL Prompt team will consider adding this extra option in a future version of the application. For yo...
You should be able to see the table or view definition by hovering over it. When you hover over one of these objects you should see a hint appear showing you which sort of object it is (if you don't see these hints then you may have to turn on hinting - SQL Prompt > Options > Behaviour > Information Panels > Enable Object Definition Hints). If you click on these hints that appear then it will bring up the object definition (schema) window.
If you resize this window then it should stay that size for the duration of the session that you're working in. / comments
You should be able to see the table or view definition by hovering over it. When you hover over one of these objects you should see a hint appear showing you which sort of object it is (if you don'...
I've passed this onto the development team. Hopefully this is something that they can improve on in the future and make SQL Prompt more intelligent in this area. For your reference the feature request tracking code is: SP-1606 / comments
I've passed this onto the development team. Hopefully this is something that they can improve on in the future and make SQL Prompt more intelligent in this area. For your reference the feature requ...
Does this seem to happen on all tables (system tables and user tables), or is it certain objects that it affects?
Do you have SQL Server Management Studio installed and, if so, does the tab key work as expected when using SSMS rather than VS2008? Has the tab key ever worked in VS2008 and if so were there any changes to VS just before it stopped working? Do you have any other third party add-ins installed?
If it works in SSMS and doesn't work with any tables at all, I'd be inclined to try a reinstall of SQL Prompt to see if this reinstates the key bindings. / comments
Does this seem to happen on all tables (system tables and user tables), or is it certain objects that it affects?
Do you have SQL Server Management Studio installed and, if so, does the tab key wor...
This is currently not possible in SQL Compare, so I've created a feature request for you. The developers will consider this when working on the next version of SQL Compare. For your reference the feature tracking code is: SC-4296 / comments
This is currently not possible in SQL Compare, so I've created a feature request for you. The developers will consider this when working on the next version of SQL Compare. For your reference the f...
When SQL Data Compare compares the databases it does this without any lock on the tables (we even use WITH NOLOCK). However, when you run the synchronization the destination database will get locks on the specific tables while the transaction is run. This is controlled by SQL Server in the same way that if you just run your own updates\inserts\deletes on a table there will be locks while the data is changing. / comments
When SQL Data Compare compares the databases it does this without any lock on the tables (we even use WITH NOLOCK). However, when you run the synchronization the destination database will get locks...
Thanks for your feedback. I've raised this as a feature request in our issue tracking software. The product manager and developers will decide how important this feature is and whether it will be implemented in the future. This will depend on a number of considerations including how many users it would benefit.
For your reference the feature tracking code is: SP-1592 / comments
Thanks for your feedback. I've raised this as a feature request in our issue tracking software. The product manager and developers will decide how important this feature is and whether it will be i...
SQL Compare, by default, will not parse different column order of tables as having a real difference i.e. they will be seen as identical objects in the top pane and the column order won't be changed when synchronizing. However, if you select the option to 'Force column order' they will be shown as different objects in the top pane of the results and this column order will be synchronized between the two tables.
The bottom pane (SQL Differences) is purely a textual comparison. It will show you the differences even if they aren't seen as real differences in the top pane. Would you like, in some way, to be able to rearrange and sort the text in the SQL Differences pane so that it matches up the columns and makes it easier to see the differences? / comments
SQL Compare, by default, will not parse different column order of tables as having a real difference i.e. they will be seen as identical objects in the top pane and the column order won't be change...
Thanks for the feedback. There have been a number of users ask if it would be possible to add their own alerts. This is something that we're considering for a future version of SQL Response. I've added your comments to the feature request. For your reference the feature request tracking code is: SSR-1188 / comments
Thanks for the feedback. There have been a number of users ask if it would be possible to add their own alerts. This is something that we're considering for a future version of SQL Response. I've a...