Posts
Sort by recent activity
So now 'Find Invalid Objects' no longer works
After the generous download of SQL Prompt to get everything working again I am seeing that 'Find Invalid Objects' no longer works - the screen comes up - it sees the server - but the second dropdow...
Cannot no longer use product
I have my own version of SQL Prompt I use at work. With whatever just changed, I can no longer use it - the product does not 'see' me. I deallocated and reallocated - but since I do not have 'local...
SQL Search - I uninstalled and reinstalled - clicking on the button = no joy
Any idea what this might be? SSMS is 18.5.1. I have SQL Prompt 10.3.2.15491.I used to have 3 monitors - now I have 2 - could the window be popping up in an unviewable area?Thanks,Doug
Remove Brackets no longer functions like it used to - 10.0.10.13591
Previously, if I had this string from dragging over columns[ResponseID], [StudyID], [StudyProtocolID], [SubjectVisitInterviewResponseID], [SubjectVisitInterviewItemID]Pressing Ctrl-B Ctrl-B would g...
Bug in the scripting of Extended Properties in SQL Compare
Team Awesome,When I use SQL Compare to compare extended properties, I see below as the metadata for a column'The CheckSum of all columns in a table except SourceSystem, StartDate, EndDate, IsActive...
Why is SQL Compare flagging Extended Properties as out of sync?
I'm seeing an odd issue.SQL Compare is flagging the lines below across 2 serversEXEC sp_addextendedproperty N'MS_Description', N'This is a table of the Visit Status References.', 'SCHEMA', N'dbo', ...
Upgrade woes
I just upgraded to the latest version of SQL Prompt. While upgrading I was presented with a modal error window 'Cannot find one or more components. Please reinstall the application.'What file do I ...
How come SQL Prompt doesn't flag Invalid Synonyms in the 'Find Invalid Objects' routine
It is easy enoughSELECT DB_NAME() AS DBName, Name AS Synonym, base_object_name AS RefersTo, 'DROP SYNONYM ' + SCHEMA_NAME( schema_id) + '.' + Name + ';' AS FixFROM sys.synonymsWHERE DB_ID( PARSENAM...
How come SQL Prompt doesn't flag Invalid Synonyms in the 'Find Invalid Objects' routine
It is easy enough<div>SELECT DB_NAME() AS DBName, Name AS Synonym, base_object_name AS RefersTo,
'DROP SYNONYM ' + SCHEMA_NAME( schema_id) + '.' + Name + ';' AS Fix
<span style="background-color: t...
Install SQL Prompt for 2008 when it's installed for 2012 and 20017
Team RedGate,Is there a way for me to enable SQL Prompt on my machine for my 2008 install? I installed it for 2012 and 2017, but I cannot see how to install/reinstall it for SQL 2008.TIA,Doug