Posts
Sort by recent activity
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
Error in SQL Prompt 9
This code will cause SQL Prompt to flag @totalRecords as 'Variable declared but never used.'
DECLARE
@totalRecords INT;
IF OBJECT_ID('tempdb.dbo.#AssessmentDetails','U' ) IS NOT NULL
BEGIN
DROP ...
Bug with find unused variable and parameters
When I run 'Find Unused Variables and Parameters' you flag @ID as 'The value here is never used.'
DECLARE@ID INT = ISNULL( ( SELECT MAX( BatchID ) FROM dbo.RDIBatch ), 1 );
DBCC CHECKIDENT ( RDIBa...
Bug - we exclude comparing Users - compare errors out comparing users
We are comparing 2 versions of our DB. We explicitly uncheck comparing users - we receive the following error:
A duplicate definition was found for the user 'xxxx'. Ensure that case sensitivity opt...