Posts
Sort by recent activity
SQL Search has stopped indexing stored procedures &functions
I noticed that SQL Search was not returning all stored procedures that had certain words in them (for example, the word "daily") because I had just changed a bunch of them and added that word.
I tr...
Error during "find unused variables and parameters"
The "find unused variables and parameters" functionality of SQL Prompt 5 is very useful to me for cleaning up T-SQL.
Unfortunately it has stopped working on my machine (Windows 7 32-bit, SQL Serve...
Error on v3 Commit Changes tab: Timeout expired.
Rest of error msg: " The timeout period elapsed prior to completion of the operation or the server is not responding."
Began getting these timeout errors on source controlled databases yesterday. T...
Data Compare 10.2.0.315 - generated sync script contains err
The sync script that is generated by the deployment wizard contains an error when there is a where clause specified on the table during comparison.
Here is the where clause that I specified when I ...
Error when running "find invalid objects"
I get the following error when I right-click on some of our databases (SQL Server 2008 R2 64-bit) and select "find invalid objects" (SQL Prompt 5.3.2.2).
"You have insufficient permissions to find ...
SQL Prompt 5.1.6 / VS2010 - hover over table name no prompt
When I hover the mouse cursor over a table name (or view name) I am expecting to see a pop-up that allows me to expand the table (or view) definition like it does in SSMS 2008 with SQL Prompt 5.1....
Unable to resolve object '[INFORMATION_SCHEMA].[TABLES]'
The "message report" (v2.6.1.47) has many occurences of the error message above. In one example the stored procedure contains this code:
SELECT 1
FROM [INFORMATION_SCHEMA].[TABLES]
WHERE [TABLE_NA...