6 results found
Can't see Full Database name
using LocalDB, the database path names can be rather long, and in the Sql Prompt Invalid objects UI, there isn't a way to expand the database name, no pull handles or widening of the screen doesn't change the comboboxs dimensions which makes it hard to find the one I need without clicking through each one.2 votes
Find invalid objects in multiple databases
Please could you add an option to check for invalid objects in multiple databases and to be able to export the results in either a single file or 1 per database. It's a real pain doing 1 at a time and manually selecting the results to do a copy/paste.4 votes
Add option to check if object exists when creating stored procedure
It would be helpful if you would add an option to check if the objects used in a stored procedure really exist when creating it.
CREATE OR ALTER PROCEDURE [dbo] [SelectFromTableThatDoesNotExist].
SELECT * FROM [dbo] [NonExistingTable];
The table used in the procedure does not exist, but the procedure can be created without errors. In this case, it would be desirable if SQL Prompt had an option to output an error when creating the procedure.3 votes
Running "Find Invalid Objects" will crash SSMS if stored procedure is encrypted
If any stored procedures in the database are encrypted then "Find Invalid Objects" will get a null reference and prompt to restart SSMS.3 votes
Ability to Save invalid objects list instead of re-running entire database each time
When you are working with a rather large database it would be nice to be able to save a list of invalid objects to come back rather than having to re-run through the entire database again.6 votes
Extend 'Find Invalid objects' to find other 'problems'. E.g. unaliased fields, wildcards etc.
It would be lovely to find other elements in the database that may not stop it from working right now but are 'problems waiting to happen'. Other examples might be to search for field names that clash with reserved terms.11 votes
- Don't see your idea?