AdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
My feedback
-
2 votes
An error occurred while saving the comment -
7 votes
An error occurred while saving the comment Would a binary(n) not be sufficient?
-
325 votes
An error occurred while saving the comment Chojrak can you please elaborate?
-
23 votes
An error occurred while saving the comment thanx for the data. We have found the root cause of the issue and will fix in an upcoming SSMS release
An error occurred while saving the comment Thanx John but can you also provide what the expected script should be for your tables? What kind of external data source are they using? We need to know how the table was created in order to create the repro for debugging. Sql DW supports one kind of data source, Sql server another, and Sql DB something else.
An error occurred while saving the comment What type of external data source is involved for these failures? AFAIK, Azure SQL Database only supports RDBMS for elastic query, not BLOB_STORAGE etc. The preview information page for elastic query https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-overview specifically mentions that scripting these tables is not yet supported in SSMS.
-
2 votes
An error occurred while saving the comment Can you validate if you still see the issue after unchecking the option Tools > General > "Use hardware graphics acceleration if available" ?
thanks,
Dinakar -
1 vote
An error occurred while saving the comment hi Anthony,
Thats incorrect. Could you point us to where/when in SSMS does it "force" you to install SQL Server?
-
4 votes
An error occurred while saving the comment Thank you for the feedback. This issue will be addressed in an upcoming SQL Server 2019 CU. Tentatively CU2.
-
61 votes
An error occurred while saving the comment Thanks for the clarification. We'll keep this open for future votes.
-
3 votes
An error occurred while saving the comment hello JM
all the tools for Azure Data are listed under Tools section - https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-2017
including SQLServer module. I agree with you that most database servers are not connected to the internet. However, in our experience and in our discussions with customer, typically customers have a process for this. Such as a shared folder/site that hosts all the company approved downloads from servers to OS to tools that the company employees download from instead of every individual having to download the same tool over and over.
Having said that, we have been discussing about a "Tools pacakge" internally. Will share once we have more concrete details around it.
thank you for the feedback.
Dinakar
-
1 vote
Have you always used SSMS to configure your system? I.e. not other tools or straight T-SQL? Is it a coincidence that for both columns you have a value of 14420? Is that a value you recall explicitly setting?
From what you are telling me, it looks like SSMS is assuming that 14420 is a number of days (as opposed to a number of minutes), hence it can’t handle it because “it is too big”).
More investigation going on…
Thanks,
-Matteo -
5 votes
This is indeed an unintended removal. It only affected SQLEXPRESS.
Thanks for the reporting it.
We’ll fix it in a future release of SSMS 18.×.An error occurred while saving the comment hi Samrat
Are both Import Data and Export Data disabled? or just one of them?
thanks,
Dinakar -
10 votes
An error occurred while saving the comment Hello
Please use Debugging feature in SSDT. TSQL Debugging has been deprecated for now.AdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
·
-
13 votes
Sorry folks, but we are not able to repro this issue (either using SSMS 17.9.1 or SSMS 18 Preview 7).
Since multiple people out there are reporting this issue, it is obvious that we are missing something that is specific to your environment or configuration.
Could you help us out and try to describe a little better your subscription/environment/account/permissions?
For example, does the following mainstream scenario works for you all:
1) Connect to Azure Portal
2) Create SQL server+database
3) Go to SSMS and connect to
4) Add firewall ruleIf it does, then can you identify what is different between the case where it works and the case where it does not?
Thanks,
-MatteoAn error occurred while saving the comment Please try with latest GA - 17.9.1 or 18 Preview 6 and post back if you still see the issue.
AdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
·
-
3 votes
An error occurred while saving the comment In the first case:
EXEC sp_execute_external_script @language = N’Python’,
@script = N’import re, pandas
Ret = InputDataSet
Ret[“an”] = pandas.Series([re.sub(”[^0-9]”, “”, i) for i in Ret[“an”]], index = Ret.index, dtype = “int32″)‘,
@input_data_1 = N’SELECT an FROM alphanum’,
@output_data = N’Ret’we would treat @output_data as a user defined parameter and expect the params clause. There is no way for us to know whether @output_data is a misspelling of @output_data_1_name or the user wants a parameter @output_data.
There are two issues in the second example:
EXEC sp_execute_external_script @language = N’Python’,
@script = N’import re, pandas
Ret = InputDataSet
Ret[“an”] = pandas.Series([re.sub(”[^0-9]”, “”, i) for i in Ret[“an”]], index = Ret.index, dtype = “int32″)‘,
@input_data_1 = N’SELECT an FROM alphanum’,
@output_name = N’Ret’,
@params = N’@Ret int’@params should be before @output_name and should contain the declaration of the @output_name parameter, not the value N'Ret'. Something like:
EXEC sp_execute_external_script
@language = N'Python',
@script = N'...',
@input_data_1 = N'SELECT an FROM alphanum',
@params = N'@output_name nvarchar(max)',
@output_name = N'Ret' -
4 votes
An error occurred while saving the comment Thank you for reporting this. This will be fixed in the next CU for SQL Server 2016 SP2.
-
5 votes
An error occurred while saving the comment Does this happen consistently or only the first initiation of SSMS?
Also, please share version info for SSMS/SSIS and what instances they are connecting to so we can figure this out.thanks,
DinakarAdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
·
-
4 votes
Upvotes: 1
An error occurred while saving the comment Could you validate if the issue exists with the latest version of SSMS - 17.9.1 and post back?
Also, please validate with SSMS 18 Preview 5.thanks
DinakarAdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
·
-
5 votes
Upvotes: 6
An error occurred while saving the comment Do you get any syntax error when creating Certificates or Keys?
Thanks,
DinakarAdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
·
-
4 votes
An error occurred while saving the comment The error you report indicates that we are unable to read the Vulnerability Assessment rule store which is embedded as a resource in one of the SqlServer module’s dlls.
Unfortunately, we have been unable to reproduce this error. Perhaps you can provide some more information on how to reproduce. Specifically:
1. What environment are you running on? Are there any special restrictions applied to your PowerShell environment?
2. Have you tried on other machines? Does it reproduce there too?
3. Are you running just the Invoke-SqlVulnerabilityAssessmentScan cmdlet or is something taking place before that? What happens when you just run the one command?
4. Any other information that you think may be pertinent to reproducing?
Thanks -
2 votes
An error occurred while saving the comment so this is a bit lame but in SSMS 17.x you need to set this environment variable to the DNS suffix of blob storage for the cloud you want: AZUREBLOBDNSNAME
The default is blob.core.windows.net.
For US Government cloud I think you would set AZUREBLOBDNSNAME environment variable to "blob.core.usgovcloudapi.net"I think this is fixed in the SSMS 18 preview, can you try it there?
If possible, can you confirm which version of SQL Server you were using? Thanks