How can we help you today? How can we help you today?
rhodrie
Activity overview Badges (0) Posts (2) Comments (16)

Activity overview

Latest activity by rhodrie

Still struggling several years on with this one (whenever I have to re-setup an environment - long enough having passed since I fudged a solution the previous time.) https://productsupport.red-gate.com/hc/en-us/articles/360007874773-The-partition-scheme-xxx-on-table-yyy-was-not-found doesn't work (and has a 0/23 people found this useful rating) / comments
  1. Community
  2. SQL Source Control
  3. Partition scheme
Still struggling several years on with this one (whenever I have to re-setup an environment - long enough having passed since I fudged a solution the previous time.)https://productsupport.red-gate....
0 votes
Still struggling several years on with this one (whenever I have to re-setup an environment - long enough having passed since I fudged a solution the previous time.) https://productsupport.red-gate.com/hc/en-us/articles/360007874773-The-partition-scheme-xxx-on-table-yyy-was-not-found doesn't work (and has a 0/23 people found this useful rating) / comments
  1. Community
  2. SQL Source Control
  3. Partition scheme
Still struggling several years on with this one (whenever I have to re-setup an environment - long enough having passed since I fudged a solution the previous time.)https://productsupport.red-gate....
0 votes
Installed SQL History 10.13.0.31319 this morning - seems to solve the issues I've been having with SQL History.  It also introduces SQL History as a tab within SSMS (the pop out window is still available by clicking the history icon in the bottom right of this tab.) / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt update v10.12.5.30313 wiped out Tab History
Installed SQL History 10.13.0.31319 this morning - seems to solve the issues I've been having with SQL History.  It also introduces SQL History as a tab within SSMS (the pop out window is still ava...
0 votes
I run SSMS under 3 different accounts depending on the environments I'm connecting to.  Since the change from "SavedTabs.db" to "SqlHistory.db" it is now only possible to run SSMS under one Windows account at a time.  To change to an instance of SSMS under a different Windows account I must first close all instances and restart the RedGateClient service.  If I try to run SSMS under multiple Windows accounts I get the "Access to the path is denied" error on the 2nd instance. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt update v10.12.5.30313 wiped out Tab History
I run SSMS under 3 different accounts depending on the environments I'm connecting to.  Since the change from "SavedTabs.db" to "SqlHistory.db" it is now only possible to run SSMS under one Windows...
0 votes
I run SSMS under 3 different accounts depending on the environments I'm connecting to.  Since the change from "SavedTabs.db" to "SqlHistory.db" it is now only possibly to run SSMS under one Windows account at a time.  To change to an instance of SSMS under a different Windows account I must first close all instances and restart the RedGateClient service.  If I try to run SSMS under multiple Windows accounts I get the "Access to the path is denied" error on the 2nd instance. / comments
  1. Community
  2. SQL Prompt
  3. Tab History is Blank
I run SSMS under 3 different accounts depending on the environments I'm connecting to.  Since the change from "SavedTabs.db" to "SqlHistory.db" it is now only possibly to run SSMS under one Windows...
0 votes
Try merging branches with Migration Scripts.  Or rather, don't. It is a world of pain. / comments
  1. Community
  2. SQL Source Control
  3. How would workflow change if using a shared model with branching?
Try merging branches with Migration Scripts.  Or rather, don't. It is a world of pain.
0 votes
History window differences
  1. Community
  2. SQL Source Control
The difference navigated to by Previ or Next is hidden by the immovable 'Update your database to the selected version' bar.  The bottom of the right hand side scroll bar is also hidden by this bar.
0 followers 0 comments 0 votes
[image] I have two monitors with the primary on the right and SSMS open in the primary.  The hover window opens right aligned in the left hand monitor and can disappear if I try to reach it! / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 9.5.5.9830 in SSMS version 15.0.18118.0 Can't click on hover
I have two monitors with the primary on the right and SSMS open in the primary.  The hover window opens right aligned in the left hand monitor and can disappear if I try to reach it!
0 votes
I had to rollback SQL Prompt v 9.5.5 to 9.5.3 as SSMS memory usage ballooned to 3 GB - inevitably performance plummeted.  I've braved 9.5.6 this morning, so I'll see how it goes. / comments
  1. Community
  2. SQL Prompt
  3. SSMS freezing with SQL Prompt
I had to rollback SQL Prompt v 9.5.5 to 9.5.3 as SSMS memory usage ballooned to 3 GB - inevitably performance plummeted.  I've braved 9.5.6 this morning, so I'll see how it goes.
0 votes
This script pulls stored procedure and function header comments starting with @procedure name and ending with ----- into the MS_Description extended property used by SQL Doc. DECLARE fred CURSOR FORWARD_ONLY FOR SELECT s2.name, s2.type, s3.name ,SUBSTRING(definition, CHARINDEX(CHAR(13),definition,CHARINDEX('@procedure name',definition,1)), CHARINDEX('-----',definition,CHARINDEX('@procedure name',definition,1))-CHARINDEX('@procedure name',definition,1)) FROM sys.sql_modules s1 JOIN sys.objects s2 ON s1.object_id = s2.object_id LEFT JOIN sys.schemas s3 ON s2.schema_id = s3.schema_id WHERE s1.definition LIKE '%@procedure name%' AND s2.type IN ('IF','FN','P') ORDER BY s2.type, s2.name DECLARE @objname VARCHAR(MAX), @type VARCHAR(MAX), @schemaname VARCHAR(MAX), @desc VARCHAR(MAX), @sql VARCHAR(MAX), @systype VARCHAR(MAX) OPEN fred FETCH NEXT FROM fred INTO @objname , @type , @schemaname , @desc WHILE @@FETCH_STATUS=0 BEGIN SET @systype = CASE @type WHEN 'IF' THEN 'FUNCTION' WHEN 'FN' THEN 'FUNCTION' WHEN 'P' THEN 'PROCEDURE' END SET @desc = REPLACE(@desc,'''','''''') SET @objname = '['+@objname+']' IF EXISTS ( SELECT 1 FROM sys.extended_properties WHERE major_id = OBJECT_ID('['+@schemaname+'].'+@objname) AND minor_id = 0 ) BEGIN SET @sql = 'EXEC sys.sp_dropextendedproperty @name = ''MS_Description'', @level0type = ''SCHEMA'', @level0name = '''+@schemaname+''', @level1type = '''+@systype+''', @level1name = ' + @objname + '; ' PRINT @sql BEGIN TRY EXEC(@sql) END TRY BEGIN CATCH END CATCH; END SET @sql = 'EXEC sys.sp_addextendedproperty @name = ''MS_Description'', @value = ''' + @desc + ''', @level0type = ''SCHEMA'', @level0name = '''+@schemaname+''', @level1type = '''+@systype+''', @level1name = ' + @objname + '; ' PRINT @sql EXEC(@sql) FETCH NEXT FROM fred INTO @objname , @type , @schemaname , @desc END CLOSE fred DEALLOCATE fred / comments
  1. Community
  2. SQL Doc
  3. Extract comments from SQL code for documentation
This script pulls stored procedure and function header comments starting with @procedure name and ending with ----- into the MS_Description extended property used by SQL Doc.DECLARE fred CURSOR F...
0 votes
Total activity
27
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
9