Repository navigation
Script as ALTER and Create Opening Blank Window with Synapse database #211
Description
In version 1.31.0 and 1.31.1 when I try script as ALTER or CREATE a View it brings up a blank window.
Steps to reproduce
- Connect to a synapse database
- Go to Views folder
- Right click on a SQL view and select "Script As Alter" or "Script As Create"
- Blank window opens instead of the underlying SQL code
I rolled back to version 1.30.0 and it started working fine.
Thanks,
Adam
Activity
croblesm commentedon May 7, 2025
Christopher Suh (@cssuh), this is probably similar issue as microsoft/vscode-mssql#19312
tanmoycuat commentedon May 8, 2025
Any update on this issue
cssuh commentedon May 9, 2025
Hi Adam Campbell (@adamcamp7) Tanmoy Santra (@tanmoycuat) , when you run into this issue, do you see any errors in the developer tools console? (Help -> Dev Tools Console)
tanmoycuat commentedon May 9, 2025
Didn't find any error on the console Christopher Suh (@cssuh) ! Let me know if you need more information.
cssuh commentedon May 9, 2025
Tanmoy Santra (@tanmoycuat) thanks for the screenshot, just a few additional questions:
tanmoycuat commentedon May 9, 2025
aasimkhan30 commentedon May 12, 2025
Thanks for reporting this issue!
It looks like the problem might be related to a scripting error coming from the SQL Tools Service.
To help us investigate further, could you please do the following:
Ctrl+Shift+PorCmd+Shift+P).> Developer: Open Extensions Log Folder.ms-mssql.mssql.sqltools.logfile inside that folder.Please check if there are any log entries containing the phrase
scripting error progress event.If you find such entries, copy the relevant section of the log and paste it here in the issue.
Be sure to redact any sensitive information, such as server names, IP addresses, or user credentials, before sharing.
Let us know what you find — this will help us diagnose the issue more accurately. Thanks!
aasimkhan30 commentedon May 12, 2025
Hi Adam Campbell (@adamcamp7) and Tanmoy Santra (@tanmoycuat),
Thanks for reporting this. I was able to reproduce the issue in version 1.31. It appears to be caused by some options not being set correctly within the extension.
The Create View scripting issue should be resolved with the changes in microsoft/vscode-mssql#19349, which will be included in the next release.
However, the ALTER script still seems to be broken.
David Shiflet (@shueybubbles) — I’m seeing the same error in both VS Code and SSMS. Do you happen to know what might be causing this? From the docs, it seems alter statements are supported by synapse https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-view-transact-sql?view=sql-server-ver16
SSMS screenshot:
[-]Script as ALTER and Create Opening Blank Window - Version 1.31[/-][+]Script as ALTER and Create Opening Blank Window with Synapse database[/+]aasimkhan30 commentedon Nov 5, 2025
Transferring issue to SMO as it is something that needs to be fixed in this library.