User profile for 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

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

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

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

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

Message from support "We are planning to fix this issue around Nov December this year." [image] / comments

Message from support "We are planning to fix this issue around Nov December this year."

0 votes

I can't see an update / comments

I can't see an update

0 votes

Re-installed SQL Doc 3 after SIP framework re-install. Still doesn't work. What's more it doesn't work against a SQL 2008 R2 database either. Not impressed. / comments

Re-installed SQL Doc 3 after SIP framework re-install. Still doesn't work. What's more it doesn't work against a SQL 2008 R2 database either. Not impressed.

0 votes

Thanks chadhattabaugh - I had this error too. SQL Doc 3 error still persists though. / comments

Thanks chadhattabaugh - I had this error too. SQL Doc 3 error still persists though.

0 votes

I have it and it connects to SQL 2014 [image] but it crashes each and every time I try to add a table column description. [image] / comments

I have it and it connects to SQL 2014 but it crashes each and every time I try to add a table column description.

0 votes

Ditto / comments

Ditto

0 votes

This is still an issue in SQL Prompt 5.3.2.2 Also it does not recognise ROW_NUMBER() / comments

This is still an issue in SQL Prompt 5.3.2.2 Also it does not recognise ROW_NUMBER()