) ... intellisense not picking correct columns
- 0000111: [General] GOs in comments run incorrectly
- 0000414: [Intellisense List] Templates should only show in the intellisense list if the user has typed the exact template abbreviation
- 0000413: [Intellisense List] Remove duplicate items from the intellisense list
SqlAssist - 1.3.155.0 -- 3/7/2006
=====================
- 0000398: [Intellisense List] Default values in stored proc parameter list prevent parsing those parameters
- 0000395: [Text Editor] Ctrl Shift does not extend the selection if auto-case-correct occurs
- 0000396: [Intellisense List] "More" buttton is clipped off in VS2005
- 0000397: [Intellisense List] Generated foreign keys still sometimes appear before actual foreign keys in the intellisense list
- 0000408: [General] Toolbars insist on being shown when an SQL file is active
- 0000403: [Build] We do not support the "T-SQL90" Visual Studio document type, which is created in VS2005 database projects
- 0000394: [Install] We need to support non-admin users (install as admin and select "All Users")
SqlAssist - 1.3.154.0 -- 2/27/2006
=====================
- 0000348: [Intellisense List] Show field names without having to type a table name or an alias
- 0000356: [Install] Make VS 2003 and 2005 versions work together
- 0000386: [Intellisense List] Make auto-scroll-to in intellisense list smarter
- 0000381: [Intellisense List] Since we are limiting the total number of elements that can be shown in the list, add a "more" button to optionally show all
- 0000361: [General] Increase the speed of the initial database parser... this takes too long for large DBs
- 0000378: [General] Make VS2003 and VS2005 work nicely together on the same machine
- 0000376: [General] Turn off connection pooling so connections are closed as soon as sql files are closed
- 0000377: [General] Add support for Visual Studio 2005's document type called "SQL Script"
SqlAssist - 1.3.153.0
=====================
- 0000372: [Intellisense List] Aliases are still not always parsed correctly
- 0000370: [Intellisense List] Stored Procedure parameters not always parsing correctly
- 0000371: [General] Speed up initial parsing of the database
- 0000375: [General] Seemingly random (and frequent) crashes in VS2005
- 0000368: [Object Explorer] Crash on scripting a stored proc from the explorer window
SqlAssist - 1.3.152.0
=====================
- 0000367: [Intellisense List] Aliases not picking up column names when defined using the "AS" keyword
- 0000364: [Text Editor] Case correction corrects when it shouldn't
SqlAssist - 1.3.151.0
=====================
- 0000330: [Text Editor] Keyboard mappings other than US English do not work properly
- 0000363: [General] On initial install in Visual Studio 2005 we see two SqlAssist menus
- 0000362: [General] On initial config, if you user ellects to "assign shortcuts" and has the "(default)" scheme, we crash
- 0000332: [Intellisense List] "inserted" and "deleted" tables in triggers do not offer column names in intellisense.
- 0000359: [Sql Output] Using the "script" command in the SqlAsisst Explorer should cause a reparse of the file after insert
SqlAssist - 1.2.150.0
=====================
- 0000357: [General] Increase the speed of the initial database parser... this takes too long for large DBs
- 0000360: [Intellisense List] Add auto-join for Temp Tables (join text based on the JOIN configuration)
- 0000351: [Intellisense List] Typing an underscore causes an open intellisense list to close
- 0000358: [Intellisense List] Aliases are not always parsed right after they are defined
SqlAssist - 1.2.149.0
=====================
- 0000350: [General] SqlAssist Main Menu item does not always show properly in VS 2005
- 0000346: [Intellisense List] Make field names show in UPDATE statements
- 0000345: [Intellisense List] Make fields show in INSERT INTO statements
- 0000343: [Text Editor] Correct case does not correct the case on movement keys
SqlAssist - 1.2.147.0
=====================
- 0000000: [General] Fixed several more crashes in 2005 version, all due to cross-thread access of controls. I hope we finally have this shored up
- 0000000: [General] Fixed menu item so that it gets rebuilt if the UI is reset. Resetting the UI is still manual ("devenv /setup" on the commandline) though, so the install will need to be fixed to do this automatically
- 0000000: [General] Fix the 2005 version to automatically map the user's key-mappings on first startup
SqlAssist - 1.2.146.0
=====================
- 0000342: [General] Fixed numerous crashes, mostly in 2005 version, due to cross-thread access of controls
- 0000326: [General] Improved parsing performance of the "JOIN pattern" function, and make it on by default
- 0000325: [Object Explorer] Make "Script" function for triggers and stored procedures include "drop trigger" statement
SqlAssist - 1.2.145.0
=====================
- 0000323: [General] "Sql Script" files do not work in database projects
- 0000327: [General] Does not work as a non-admin user
- 0000317: [Text Editor] Prevent Crash Only (proper fix still to come): Keyboard mappings other than US English do not work properly
- 0000329: [General] Prevent Crash Only (proper fix still to come): Crash on startup if using Visual Studio other than English version
SqlAssist - 1.2.144.0
=====================
- 0000321: [Intellisense List] Add space bar as an optional key to enter the selected item from the intellisense list into the document
- 0000320: [Text Editor] Text editing in VS.NET 2005 causes crash when window is horizontally scrolled
- 0000319: [Sql Output] Crash when clicking on Line Number link in output window in VS.NET 2005
SqlAssist - 1.2.143.0
=====================
- 0000315: [Intellisense List] Intellisense behaves funny when on lines shortly after a DECLARE statement
- 0000311: [General] Does not properly read SQL Server Express databases
- 0000314: [Build] Make auto-JOIN text improved by searching for matches by column name
SqlAssist - 1.2.142.0
=====================
- 0000309: [General] Was impossible to turn off Tip-of-the-Day (sorry!!!)
- 0000311: [General] Licensing fixes
- 0000312: [General] We now support Visual Studio .NET 2005!
SqlAssist - 1.2.140.0
=====================
- 0000266: [Object Explorer] Add data types to columns in object explorer
- 0000310: [General] Exception reported when switching between certain types of windows (Crystal Reports and Datasets?)
- 0000308: [General] Database name in combobox may contain incorrect name
- 0000297: [Text Editor] Block select and manipulation causes Visual Studio to crash
SqlAssist - 1.2.139.0
=====================
- 0000105: [General] Make a trial period screen and all associated functionality
SqlAssist - 1.2.130.0
=====================
- 0000305: [General] Add a Daily Tips feature
SqlAssist - 1.2.129.0
=====================
- 0000307: [Install] When installing to a different directory after uninstalling, application may not work correctly
- 0000306: [General] Improve upgrade dialog. Make information more detailed.
- 0000304: [Build] Stop displaying the intellisense list on as it shows up too often that way
- 0000071: [Build] Jump to line of code from messages output
SqlAssist - 1.0.126.0
=====================
- 0000287: [Templates] Show a different icon for templates that support selections
- 0000303: [Templates] Cursor does not go to "SqlAssist Cursor:" after insert if the template is a selection-based template
- 0000292: [Build] If user presses Ctrl J with the parameter info visible, the intellisense list does not come up
- 0000293: [Templates] Templates should insert entire template at the indent of the cursor
- 0000299: [Intellisense List] No longer remove characters behind the cursor when entering an item from the intellisense list
- 0000301: [Intellisense List] Parsing does not pick up the last column in temp tables created with CREATE TABLE
- 0000298: [Intellisense List] Parsing does not find table variables
- 0000290: [Intellisense List] If the intellisense list comes up unfiltered (i.e. user has typed no characters), don't select first item in list
- 0000295: [Intellisense List] Intellisense list not showing templates (and others?) after declare statement
- 0000294: [Intellisense List] Foreign Key entries showing in the intellisense list when not behind a JOIN keyword
- 0000291: [Intellisense List] Remove option to insert selected intellisense list item on . This proves to be frequently annoying
SqlAssist - 1.0.110.0
=====================
- Extend expiration date
SqlAssist - 1.0.109.0
=====================
- 0000280: [Sql Output] Make the output error message text in color
- 0000284: [Text Editor] Add @@TRANCOUNT information to InfoBar
- 0000288: [Intellisense List] Show data types after variable names in stored procedure and function declarations
- 0000283: [Intellisense List] Show datatypes after DECLARE keyword
- 0000282: [Intellisense List] Show tables after TABLE keyword
- 0000286: [Intellisense List] Show tables after INTO keyword
SqlAssist - 1.0.108.0
=====================
- 0000281: [General] Extent the expiration date to 11/30/2005
SqlAssist - 1.0.107.0
=====================
- 0000247: [Multi-Run Scripts] Loading a saved multi-run configuration back in does not properly set the radio buttons at the top
- 0000274: [General] Parsing is MUCH faster now, so we should reword the text in the options about slow parsing
- 0000279: [Sql Output] Output info and warning statements, like text from PRINT() statements
- 0000276: [Sql Output] Add more error info (error code and other info if available) to script run failures
- 0000278: [Build] Make the current parameter in the parameters info tooltip stand out more
- 0000277: [Intellisense List] Substantial performance increase in intellisense list response time, from .1 sec to .02 sec (est)
SqlAssist - 1.0.106.0
=====================
- 0000260: [Parameter Info] Parameter info does not always show
- 0000136: [Intellisense List] Alias regex match finds INTO and WHERE behind FROM statements
- 0000272: [General] A connection is not always made when opening a new document
- 0000262: [Intellisense List] Hitting no longer displays intellisense list where appropriate
- 0000264: [Intellisense List] Intellisense list is showing while in single quote but shouldn't
- 0000261: [Parameter Info] Find a way to separate the parameter info from the document text. They run into each other
- 0000269: [Parameter Info] Make parameter info hide when cursor key is typed
- 0000265: [Intellisense List] Allow keywords to show after select and where clauses
- 0000263: [Parameter Info] Parameters do not show for master database stored procedures
- 0000267: [Templates] Make changes to default MiniTemplates.sql
- 0000268: [General] Selecting a database in the combobox does not always change the connection
SqlAssist - 1.0.105.0
=====================
- 0000112: [Parameter Info] Show stored procedure parameters
- 0000129: [Parameter Info] Show function parameters
- 0000259: [Intellisense List] Templates show in the intellisense list when no characters appear before the cursor. Show templates only on exact name match
- 0000258: [Intellisense List] Add stored procedures from the master database to the stored procedure list (since these can be run from any DB)
SqlAssist - 1.0.104.0
=====================
- 0000256: [Multi-Run Scripts] Cannot use Multi-Run scripts because the ListType data binding is failing and the dialog never comes up
SqlAssist - 1.0.103.0
=====================
- 0000252: [General] If connection fails when opening a file, Visual Studio freezes until the connection times out.
- 0000251: [Intellisense List] Column parsing of temp tables picks up extra characters in column names
- 0000253: [Intellisense List] Intellisense no longer shows tables in JOIN statements when no foreign key items match typed filter.
- 0000250: [Intellisense List] Columns for temp tables not available after initial file parse (but available after subsequent parsing)
- 0000254: [Intellisense List] Substantial improvements in file parsing performance.
- 0000249: [General] When there is an update available, clicking on "yes" to upgrade brings you to the wrong site.
SqlAssist - 1.0.102.0
=====================
- 0000241: [Intellisense List] Parsing of document file can be slow, particularly when looking for temp tables
- 0000244: [Intellisense List] Temp tables not available if defined by CREATE TABLE and "NULL" or "NOT NULL" is specified in a column
- 0000248: [Object Explorer] Object explorer does not show the tree when it is initially displayed while an SQL document is open
- 0000243: [Intellisense List] After initial file parse, temp tables are not available in the intellisense list (but are later)
SqlAssist - 1.0.101.0
=====================
- 0000242: [Intellisense List] Columns appear multiple times in intellisense list if user enters an unknown table alias before the dot (.)
- 0000241: [Intellisense List] Parsing of document file can be slow, particularly when looking for temp tables
- 0000143: [Intellisense List] Include stored procedure and function arguments in variable list
- 0000226: [General] Selecting a different database from the database combobox does not always change the connection
- 0000141: [Intellisense List] Local variables declared multiple in a single DECLARE statement do not appear in the menu
- 0000151: [General] Server connection dialog doesn't really "cancel"
- 0000239: [Intellisense List] Stored Procedures and Functions do not always show in the intellisense list
- 0000237: [Intellisense List] Intellisense list does not hide when user opens templates
- 0000240: [Intellisense List] Make intellisense list show stored procedures and functions following the EXEC keyword
SqlAssist - 1.0.99.0
====================
- 0000235: [General] Info-bar still reports a connection even If the connection to a database fails
- 0000230: [Multi-Run Scripts] Add a summarized output for all databases in the Multi-Run script function
- 0000234: [Multi-Run Scripts] Make multi-run script run serially rather than in parallel
- 0000231: [Multi-Run Scripts] Multi-Run Scripts crashing when opening the dialog
- 0000233: [Sql Output] Output window does not automatically display itself (if hidden) when running multi-run scripts
- 0000227: [Templates] Templates are not shown in alphabetical order
- 0000229: [Install] Icon in add/Remove Programs list not showing properly
SqlAssist - 1.0.98.0
====================
- 0000169: [Bug] Large sql output takes a long time to populate the view
- 0000224: [Bug] Auto-size output columns crashes occasionally
- 0000223: [Bug] Occasionally the explorer window shows the cursor as a wait-cursor even when not busy
- 0000222: [Bug] Scripting a constraint from the object explorer does not work
SqlAssist - 1.0.97.0
====================
- 0000216: [Enhancement] Set public classes to internal classes for improved code obfuscation
SqlAssist - 1.0.96.0
====================
- 0000208: [Enhancement] Allow switching between output resultsets with a shortcut
- 0000220: [Enhancement] Add ability to change the resultset in the output window with a user-defined shortcut
- 0000221: [Enhancement] Add ability to change the file tab in the output window with a user-defined shortcut
- 0000219: [Bug] Icons occasionally do not show when running under Windows XP
- 0000218: [Bug] Prevent user from having to uninstall previous versions in order to install the latest version (happens automatically)
- 0000209: [Bug] Iinserting a template with something selected does not delete the selection
- 0000213: [Bug] When typing very fast, Intellisense list sometimes appea}ÞOhen it should not and has wrong filtered results
- 0000215: [Bug] Messagebox warning about too many recordsets does not mention document name
- 0000214: [Bug] When closing the intellisense list, the list should not re-show if no item was entered into the document
- 0000211: [Bug] Installing on a machine without Visual Studio installed gives a meaningless error
- 0000212: [Bug] Make Byte Arrays display correctly in the output window
SqlAssist - 1.0.95.0
====================
- 0000207: [Enhancement] Make templates support adding the current selection into template in multiple places
- 0000204: [Bug] Template files are overwritten on re-install, even if the user had edited them
- 0000205: [Bug] Running a Stored Procedure by name only will fail
- 0000206: [Bug] Check for available updates function not working correctly (incorrectly reporting no updates available)
- 0000198: [Enhancement] Add drag/drop and double-click to the object explorer
SqlAssist - 1.0.94.0
====================
- 0000203: [Enhancement] Add tooltips to the Multi-Run Script dialog controls
- 0000200: [Bug] Query textbox in the Multi-Run script dialog does not accept the Enter key
- 0000201: [Enhancement] Add ability to choose if dynamic database list in Multi-Run Scripts must have rows in returned resultsets
- 0000202: [Bug] Add versioning to the Multi-Run Script save file in case the format changes in the future
SqlAssist - 1.0.93.0
====================
- 0000188: [Bug] Do not add closing delimiter in comments
- 0000189: [Bug] Do not add closing delimiter in single-quotes
- 0000197: [Bug] Do not correct case in comments
- 0000173: [Bug] Do not correct case inside of quotes
- 0000196: [Bug] Since the single start/stop button in the info bar is confusing, make it two buttons
- 0000193: [Bug] Add messagebox to indicate missing servers in Multi-Run Script dialog
- 0000195: [Bug] Add a warning about a large number of recordsets returned
SqlAssist - 1.0.92.0
====================
- 0000191: [Bug] Object Explorer does not always refresh properly
- 0000190: [Bug] Refreshing the database dropdown toolbar on switching documents can take too long (1 second or so)
SqlAssist - 1.0.91.0
====================
- 0000184: [Bug] NotImplementedException thrown when refreshing a table in SqlAssist Explorer
- 0000187: [Bug] Double-click in templates menu does not work
- 0000185: [Enhancement] Show whether or not a script is currently active in output window with an icon
SqlAssist - 1.0.90.0
====================
- 0000183: [Bug] Output results tabs created by multi-run script do not close when document closes
- 0000172: [Bug] Intellisense list does not work behind the SET keyword
- 0000174: [Enhancement] Add triggers in the SqlAssist Explorer view
- 0000175: [Enhancement] Add columns in the SqlAssist Explorer view
- 0000176: [Enhancement] Add indexes in the SqlAssist Explorer view
- 0000177: [Enhancement] Add constraints in the SqlAssist Explorer view
- 0000178: [Enhancement] Add statistics in the SqlAssist Explorer view
- 0000179: [Enhancement] Add keys in the SqlAssist Explorer view
- 0000180: [Bug] Show context menu options in explorer window only when they are available
- 0000181: [Bug] SqlAssist Explorer does not refresh when the connection in a window changes
- 0000182: [Bug] SqlAssist Explorer does not close the tree view when an SQL document closes
SqlAssist - 1.0.89.0
====================
- 0000170: [Enhancement] Add an object browser (SqlAssist Explorer) with scripting capabilities
- 0000079: [Enhancement] Option to create a new SQL file with same connection on File.NewFile command
- 0000171: [Enhancement] Add tooltips to all configuration options
- 0000168: [Enhancement] Add a connection option command for script files
- 0000167: [Bug] When intellisense list is open, shift up, ctrl down, shift ctrl home, etc. should navigate and hide the list
SqlAssist - 1.0.88.0
====================
- 0000165: [Enhancement] Add exception logging
- 0000164: [Bug] ImageList causes crash on startup
SqlAssist - 1.0.87.0
====================
- 0000162: [Enhancement] Add code obfuscation
- 0000163: [Bug] Fix problem with running queries that add "SELECT " to beginning when a DECLARE statement is present
SqlAssist - 1.0.86.0
====================
- 0000110: [Bug] Threads deadlock when pressing stop script
- 0000097: [Enhancement] Run a script on all databases on a server that fit a given criteria
- 0000158: [Bug] When entering columns or tables with spaces in them, sound them with brackets
- 0000159: [Enhancement] Ability to add user-defined abbreviations for templates.
- 0000160: [Bug] When a solution is open and you run a query with F5, VS.NET still tries to debug the solution.
- 0000107: [Enhancement] Add template interface, where the user can define templates to be automatically inserted
- 0000065: [Enhancement] Function to pretty-format all sql or selected sql
- 0000156: [Bug] Make foreign key JOIN entries obey the "return before/after AND" option.
- 0000152: [Bug] If typing "= #", the menu comes up with items to enter but shouldn't
- 0000157: [Bug] Have temp tables show in "table" list
- 0000148: [Enhancement] Add a timer to the SqlAddonControl for while a query is running
- 0000109: [Enhancement] Make the intellisense list filterable by acroynms
- 0000102: [Enhancement] Make all result set tables optionally appear on the same tab in the output window.
- 0000091: [Enhancement] Add a shortcut for beginning and ending a transaction.
- 0000090: [Enhancement] Add ability to "run" just a table name
- 0000149: [Bug] Don't allow user to change the database connection while a query is running
- 0000140: [Bug] Make intellisense menu hide when moving to another application
- 0000101: [Enhancement] Make columns in output window automatically resize
- 0000145: [Bug] Correct case on typing a comma
- 0000144: [Bug] Insert closing character ( { [ ' " does not put cursor in correct position after insert
- 0000146: [Bug] Make down arrow drop down the database combo box in the connection dialog
- 0000147: [Bug] When multiple aliases with same name exist, only columns from second are found
- 0000134: [Bug] Parsing of temp tables is buggy
- 0000135: [Bug] Hide menu if it is showing and the user clicks somewhere else in document
- 0000132: [Bug] When dialogs are open, the text window still fires events on key strokes
- 0000093: [Bug] Aliases, Variables, and TempTables are listed multiple times.
- 0000081: [Enhancement] Pop up intellisense on the following user actions
- 0000128: [Bug] Allow intellisense to display table names immediately after an "on" statement if no foreign keys match
- 0000138: [Enhancement] Add feature to insert closing quote, parentheses, etc. automatically
- 0000092: [Enhancement] Option to put words starting with the name filter at the top of the list
- 0000064: [Enhancement] Option to capitalize or lower case key words during typing
- 0000113: [Enhancement] Create a configuration dialog
- 0000089: [Bug] When typing fast, it is possible for window to come up unfiltered.
- 0000133: [Bug] Menu pops up when activating the window
- 0000131: [Bug] Dash key doesn't type at all
- 0000119: [Bug] Close result sets when editor is closed
- 0000124: [Enhancement] When dropping down the database list, keep current database selected
- 0000118: [Enhancement] Create a mappable command for activating the database dropdown
- 0000116: [Bug] Not all keys work in the edit boxes on the login control
- 0000117: [Enhancement] ESC key should set focus from the login control to the editor window
- 0000125: [Bug] Close connection when closing a window
- 0000121: [Bug] Releasing modifier keys can cause the menu to hide
- 0000126: [Enhancement] Add stored procedures to the intellisense list
- 0000127: [Enhancement] Add functions to the intellisense list
- 0000085: [Bug] Handle Developer Studio keystrokes when Visual Assist is NOT installed.
- 0000077: [Bug] DateTime fields show only the date portion in the datagrid.
- 0000122: [Bug] Double-clicking on the menu itself does not enter the information into the document
- 0000115: [Bug] Login by Sql Server authentication fails.
- 0000083: [Bug] Icons in toolbar have spaces after them
- 0000084: [Bug] Allow invoke of run on Debug.Start command
- 0000104: [Enhancement] Allow showing intellisense menu with the VS.NET key mapping for intellisense.
- 0000100: [Bug] Option to have the output window switch to the associated output when the user switches documents.
- 0000066: [Enhancement] Add ability to stop a query while it is in process
- 0000095: [Bug] Autoformat text on typing "("
- 0000067: [Enhancement] Offer a way for the user to know that a query is in process.
- 0000086: [Enhancement] Add connection info to top of window
- 0000073: [Bug] Columns of views are not displayed.
- 0000096: [Bug] "ON" list may only include a single table rather than both.
- 0000088: [Bug] If no connection is made to the DB on window creation, the _pane variable doesn't get set.
- 0000103: [Bug] When closing SQL windows, getting error message
- 0000070: [Bug] Make focus go back to the editor window when the output window is updated with data.
- 0000075: [Bug] Deadlock possible on the two threads.
- 0000087: [Bug] Performance of document parsing is bad.
- 0000080: [Bug] Getting blank aliases in list.
- 0000072: [Bug] Performance is currently terrible. This must be improved.
- 0000069: [Enhancement] Add TempTable to the list of tables.
- 0000094: [Bug] Perform initial database parse on a second thread
- 0000076: [Enhancement] Add auto-comment/uncomment multiple lines of code
- 0000082: [Enhancement] Use aliases in automatic join text.
|
|