User profile for Ben_P

Hi Dan, Are you able to try updating SQL Source Control to the latest version below: https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.7.18.19115.exe Then try SQL Prompt in SSMS 19.3 or SSMS 20.2 and let me know if the same issue occurs. / comments

Hi Dan,Are you able to try updating SQL Source Control to the latest version below:https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.7.18.19115.exeThen try SQL Promp...

0 votes

To resolve the error that you are seeing, please connect to the SQL Server instance using SSMS and delete the sql_monitor XE session: [image] Redgate Monitor should automatically recreate the session In case this does not exist in the first place or if Redgate Monitor does not recreate it, the following query should help to do this: DECLARE @target NVARCHAR(50) SELECT @target = p.name +'.' + o.name FROM sys.dm_xe_objects o INNER JOIN sys.dm_xe_packages p ON o.package_guid = p.guid WHERE o.object_type = 'target' AND (p.capabilities IS NULL OR p.capabilities <> 1) AND o.name IN ('asynchronous_file_target', 'event_file') DECLARE @sessionName NVARCHAR(100) = N'sqlmonitor_session' DECLARE @errorLogPath NVARCHAR(1000), @errorLogFolder NVARCHAR(1000) SET @errorLogPath = CAST(SERVERPROPERTY('ErrorLogFileName') AS NVARCHAR(1000)) SET @errorLogFolder = LEFT(@errorLogPath,LEN(@errorLogPath) - charindex('\',reverse(@errorLogPath),1) + 1) DECLARE @xePath NVARCHAR(1000), @xeWildCard NVARCHAR(1000), @xemWildCard NVARCHAR(1000) SET @xePath = @errorLogFolder + @sessionName + '.xel' SET @xeWildCard = @errorLogFolder + @sessionName + '*.xel' SET @xemWildCard = @errorLogFolder + @sessionName + '*.xem' DECLARE @sql NVARCHAR(MAX) IF NOT EXISTS(SELECT 1 FROM master.sys.server_event_sessions WHERE [name] = @sessionName) BEGIN     BEGIN         SET @sql = '         CREATE EVENT SESSION [' + @sessionName + '] ON SERVER         ADD EVENT sqlserver.xml_deadlock_report         ADD TARGET ' + @target + '(SET filename=N''' + @xePath + ''', max_file_size=(5))         WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)         '         EXEC(@sql)     END END Please let us know if this helps. / comments

To resolve the error that you are seeing, please connect to the SQL Server instance using SSMS and delete the sql_monitor XE session: Redgate Monitor should automatically recreate the sessionIn ca...

0 votes

Hi Michael, Thank you for your post. Are you using SSMS 18.12.1? If you are then there appears to be an issue currently with the latest version of SQL Prompt and SSMS 18.12.1. For now, the workaround is to roll back to SQL Prompt 10.14.10 as this would be before any changes were made to allow SQL Prompt to work in SSMS 20: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.10.7538.exe / comments

Hi Michael,Thank you for your post. Are you using SSMS 18.12.1? If you are then there appears to be an issue currently with the latest version of SQL Prompt and SSMS 18.12.1. For now, the workaroun...

0 votes

Hi @intGod Are you able to confirm which Style you are using when formatting the query? Or if using a custom one, could you provide a copy of that Style? This would be located in: C:\Users\Ben.Patel\AppData\Local\Red Gate\SQL Prompt 10\Styles Are you also able to provide a copy of the query that you are trying to format? / comments

Hi @intGod Are you able to confirm which Style you are using when formatting the query? Or if using a custom one, could you provide a copy of that Style? This would be located in:C:\Users\Ben.Patel...

0 votes

@jsreynolds1 I wasn't aware that it could hijack the mouse, but I understand how that would be annoying. I'll pass on the feedback to the product team for SQL Prompt. / comments

@jsreynolds1 I wasn't aware that it could hijack the mouse, but I understand how that would be annoying. I'll pass on the feedback to the product team for SQL Prompt.

0 votes

@jsreynolds1 Thank you for your post. You can clear the notification permanently by clicking the "Dismiss" option. After this the pop-up shouldn't return. / comments

@jsreynolds1 Thank you for your post. You can clear the notification permanently by clicking the "Dismiss" option. After this the pop-up shouldn't return.

0 votes

To Confirm the export to excel feature was fixed in 10.14.10: 10.14.10.7538 - Released on 14 March 2024 Fixes Fixed exporting results to excel format. Fixed "Could not load file or assembly System.Memory" exception, occurring when using SqlPrompt.Format.CommandLine.exe from FormatCommandLine.zip. / comments

To Confirm the export to excel feature was fixed in 10.14.10: 10.14.10.7538 - Released on 14 March 2024Fixes Fixed exporting results to excel format. Fixed "Could not load file or assembly System.M...

0 votes

Hi @cmbergin, Thank you for your post. A support ticket has been opened for this issue so that we can gather a bit more information to troubleshoot. / comments

Hi @cmbergin,Thank you for your post. A support ticket has been opened for this issue so that we can gather a bit more information to troubleshoot.

0 votes

Hi, thank you for your post. Is this for SQL Server 2005? If so, then this is not supported. The earliest version that SQL Prompt supports is 2012. / comments

Hi, thank you for your post. Is this for SQL Server 2005? If so, then this is not supported. The earliest version that SQL Prompt supports is 2012.

0 votes

Hi Arjan, Which version of SQL Data Compare and SQL Compare are you using? After clicking the option to send feedback, does the banner disappear? / comments

Hi Arjan,Which version of SQL Data Compare and SQL Compare are you using? After clicking the option to send feedback, does the banner disappear?

0 votes

How can we help you today?

Ben_P

Comments