How can we help you today? How can we help you today?
tk14ano
Activity overview Badges (0) Posts (0) Comments (7)

Comments

Sort by recent activity
Hi, We also have the same issue on our Azure SQL Data Warehouse. See attached screenshot SQL Prompt version: 10.14.12.7945 Azure Synapse does not support triggers. This might be the roor cause of this issue. This issue does not occur on SQL Server OnPremise.  Thanks, Chris <div>2024-04-03 11:28:56.172 +03:00 [Error] Unable to obtain CreateScript for sp_WhoIsActive</div><div>Microsoft.Data.SqlClient.SqlException (0x80131904): Catalog view 'triggers' is not supported in this version.</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.NextResult()</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Scripting.ObjectFactory.GetStoredProcedureFunction(DbConnection connection, ServerVersion serverVersion, String databaseName, String schemaName, String storedProcedureFunctionName, Func`1 objectDecoder)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Scripting.Scripter.GetStoredProcedureScripter(DbConnection connection, String schemaName, String spName, Func`1 objectDecoder)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Candidates.StoredProcedureCandidate.GetObjectScripter()</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Candidates.StoredProcedureCandidate.GetScript(ScriptType scriptType)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Candidates.AlterCandidateBase.GetCreateScript(ICreationScriptCache scriptCache)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.CommonUI.Forms.SchemaInformation.ScriptFetcher.<>c__DisplayClass1_0.<GetScriptFetcher>b__0()</div> / comments
  1. Community
  2. SQL Prompt
  3. Why Script Object as ALTER not working for SQL Pool on Azure
Hi,We also have the same issue on our Azure SQL Data Warehouse. See attached screenshotSQL Prompt version: 10.14.12.7945Azure Synapse does not support triggers. This might be the roor cause of this...
0 votes
Hi, We also have the same issue on our Azure SQL Data Warehouse. See attached screenshot SQL Prompt version: 10.14.12.7945 Azure Synapse does not support triggers. This might be the roor cause of this issue. This issue does not occur on SQL Server OnPremise.  Thanks, Chris <div>2024-04-03 11:28:56.172 +03:00 [Error] Unable to obtain CreateScript for sp_WhoIsActive</div><div>Microsoft.Data.SqlClient.SqlException (0x80131904): Catalog view 'triggers' is not supported in this version.</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.NextResult()</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Scripting.ObjectFactory.GetStoredProcedureFunction(DbConnection connection, ServerVersion serverVersion, String databaseName, String schemaName, String storedProcedureFunctionName, Func`1 objectDecoder)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Scripting.Scripter.GetStoredProcedureScripter(DbConnection connection, String schemaName, String spName, Func`1 objectDecoder)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Candidates.StoredProcedureCandidate.GetObjectScripter()</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Candidates.StoredProcedureCandidate.GetScript(ScriptType scriptType)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Candidates.AlterCandidateBase.GetCreateScript(ICreationScriptCache scriptCache)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.CommonUI.Forms.SchemaInformation.ScriptFetcher.<>c__DisplayClass1_0.<GetScriptFetcher>b__0()</div> / comments
  1. Community
  2. SQL Prompt
  3. Why Script Object as ALTER not working for SQL Pool on Azure
Hi,We also have the same issue on our Azure SQL Data Warehouse. See attached screenshotSQL Prompt version: 10.14.12.7945Azure Synapse does not support triggers. This might be the roor cause of this...
0 votes
Hi, We have the same issue on Azure SQL Data Warehouse. We cannot view the definition of Stored-Procedures. <div>2024-04-03 11:28:56.172 +03:00 [Error] Unable to obtain CreateScript for sp_WhoIsActive</div><div>Microsoft.Data.SqlClient.SqlException (0x80131904): Catalog view 'triggers' is not supported in this version.</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more)</div><div>&nbsp; &nbsp;at Microsoft.Data.SqlClient.SqlDataReader.NextResult()</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Scripting.ObjectFactory.GetStoredProcedureFunction(DbConnection connection, ServerVersion serverVersion, String databaseName, String schemaName, String storedProcedureFunctionName, Func`1 objectDecoder)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Scripting.Scripter.GetStoredProcedureScripter(DbConnection connection, String schemaName, String spName, Func`1 objectDecoder)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Candidates.StoredProcedureCandidate.GetObjectScripter()</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Candidates.StoredProcedureCandidate.GetScript(ScriptType scriptType)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Cache.Candidates.AlterCandidateBase.GetCreateScript(ICreationScriptCache scriptCache)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.CommonUI.Forms.SchemaInformation.ScriptFetcher.<>c__DisplayClass1_0.<GetScriptFetcher>b__0()</div> / comments
  1. Community
  2. SQL Prompt
  3. Why Script Object as ALTER not working for SQL Pool on Azure
Hi,We have the same issue on Azure SQL Data Warehouse. We cannot view the definition of Stored-Procedures.<div>2024-04-03 11:28:56.172 +03:00 [Error] Unable to obtain CreateScript for sp_WhoIsActiv...
0 votes
RichardL said: Hi @Leilani Thanks for your post.  Are you on the latest version? If not I've put a link to the download for it below.  ftp://support.red-gate.com/patches/SQLPrompt/25Apr2018/SQLPrompt_9.1.9.4925.exe Could you also check to see if the file exists in the location mentioned in the error message please and let us know how you get on?  Kind regards Richard Lynch.  SP-6883 : 'Open in Excel' grid result operation now works with multiple Excel instances. So happy for this. Downloading it now and will provide feedback very soon / comments
  1. Community
  2. SQL Prompt
  3. Open in Excel
RichardL said: Hi @Leilani Thanks for your post. Are you on the latest version? If not I've put a link to the download for it below. ftp://support.red-gate.com/patches/SQLPrompt/25Apr2018/SQL...
0 votes
Early feedback...seems to have fixed the issue, at least for now. I will let you know if and when I have it again. Thank you very much for fixing this. / comments
  1. Community
  2. SQL Prompt
  3. Open in Excel
Early feedback...seems to have fixed the issue, at least for now. I will let you know if and when I have it again. Thank you very much for fixing this.
0 votes
Leilani said: This started happening to me yesterday, and starting Excel in Safemode fixed the problem. However, today I'm getting the "Sorry, we couldn't find...xlsx. Is it possible it was moved, renamed or deleted?" error when I try to "Open in Excel", and starting Excel in Safemode is not fixing the problem. I can "Open in Excel" if I don't already have Excel open, but subsequent "Open in Excel" attempts result in the error. I am glad someone else had this issue because I was afraid it was just me. Mine worked only for a few days and started since then having the issue again. I stopped trying to find a solution to the problem and instead I was exiting all other excel instances (very annoying) before clicking open in Excel. / comments
  1. Community
  2. SQL Prompt
  3. Open in Excel
Leilani said: This started happening to me yesterday, and starting Excel in Safemode fixed the problem. However, today I'm getting the "Sorry, we couldn't find...xlsx. Is it possible it was ...
0 votes
I am having issues with Open In excel. When excel is already running excel the report begins to export and then excel loads, but an error message pops up on the screen. Sorry, we couldn't find: C:\user\...\AppData\Local\Temp\XXX\filename xlsx. Is it possible it was moved, renamed or deleted? When excel is closed it loads up fine with data in the excel and the file can be found in the unique Temp folder just created. I have repaired Excel but nothing works. I have changed the default save location in excel and still sql prompt tries to save the file temporarily in the temp folder. Thanks Chris / comments
  1. Community
  2. SQL Prompt
  3. Open in Excel
I am having issues with Open In excel. When excel is already running excel the report begins to export and then excel loads, but an error message pops up on the screen. Sorry, we couldn't find: C:\...
0 votes
Total activity
9
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2