OzBobWa

My feedback

  1. 174 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    74 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks everybody for providing the list. I’ve passed the info to the Visual Studio Team.

    In the meanwhile, I have 2 more requests:
    1) If you happen to have Visual Studio 2017 (version 15.9.11 or greater), could you check and see if it shows the same behavior?
    2) If you happen to have SSMS 17.9.1 on the same machine, could you check and see if it shows the same behavior?

    I’m hearing from folks here that “changing SSMS such that it disables h/w acceleration by default” is not a recommended thing to do… However, quite honestly, at this point, it may be the only option I can think about.. :-(

    -Matteo

    OzBobWa supported this idea  · 
  2. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Signup and Billing » Subscription management  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa shared this idea  · 
  3. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Signup and Billing » Subscription management  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa shared this idea  · 
  4. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa commented  · 

    Open new query
    Run
    Results Grid
    select text
    ctrl-X
    'Unsaved documents cannot be cut ...'
    Suggestion: do not show this when ctrl-x/cut in the Results Grid.

    OzBobWa supported this idea  · 
  5. 360 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa supported this idea  · 
  6. 24 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa supported this idea  · 
    OzBobWa commented  · 

    Ctrl Tab from one tab with lots of text to another tab with little text and the first tab stuff displays in the bottom half of the new tab!

    SQL Server Management Studio 15.0.18142.0
    Microsoft Analysis Services Client Tools 15.0.1389.0
    Microsoft Data Access Components (MDAC) 10.0.18362.1
    Microsoft MSXML 3.0 4.0 6.0
    Microsoft Internet Explorer 9.11.18362.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.18362

    Goodbye SSMS. Time to learn to VS2019 Data Tools.

  7. 787 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    unplanned  ·  50 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa supported this idea  · 
    OzBobWa commented  · 
  8. 5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa supported this idea  · 
    OzBobWa commented  · 

    select * from table FOR JSON AUTO
    results window
    click JSON output

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Unable to show XML. The following error happened:
    An error occurred while parsing EntityName. Line 1, position 37448.

    One solution is to increase the number of characters retrieved from the server for XML data. To change this setting, on the Tools menu, click Options.

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

  9. 59 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Logic Apps » Management  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa supported this idea  · 
  10. 8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    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 rule

    If it does, then can you identify what is different between the case where it works and the case where it does not?

    Thanks,
    -Matteo

    OzBobWa commented  · 

    you'll need two azure subscriptions
    one that is your default one in azure portal
    2nd one that contains the SQL server and DB

    OzBobWa supported this idea  · 
    OzBobWa commented  · 

    There is an issue with the error message not detailing the error returned from Azure.

    One possible error is that the Microsoft Account signed in on SSMS does not have permission to add a new IP to the firewall exception list.

    Try signing in as the owner of the subscription

  11. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    OzBobWa shared this idea  · 
  12. 178 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  8 comments  ·  SQL Server » Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa supported this idea  · 
  13. 10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 23

    <=-=Aug 1 2017 1:08PM=-=>

    Would be great to get this added.

    <=-=Nov 6 2017 1:42AM=-=>

    This is supported for “non build” scripts, not sure the use case for having for “build” files

    <=-=Nov 7 2017 7:49PM=-=>

    The scenario for supporting the CREATE OR ALTER in a build .sql for a stored procedure, is as follows:

    Since the [Test, modify, fail, modify Stored Proc, modify Test -> pass] cycle is very labour intensive currently in the VS DB project with the DB SQL Test feature, I have been experimenting with how to make writing the SQL for the test in a quicker manner.

    I have written a SQL file that has [Arrange, Act, Assert] set of SQL statements, and after finished developing the final SQL ‘Assert’ statements they are then added to the DB Test file type’s formal Assertions.

    The fact that running the Build of a DB and…

    OzBobWa supported this idea  · 
  14. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  (General Feedback) » azure.microsoft.com  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa shared this idea  · 
  15. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa supported this idea  · 
    OzBobWa commented  · 

    17.3

  16. 8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    unplanned  ·  1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa commented  · 
  17. 11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. 19 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa commented  · 

    There is a SSMS bug when importing Settings to get a Dark Theme.
    Please upvote this to get it fixed: https://feedback.azure.com/forums/908035-sql-server/suggestions/35057257-dark-theme-ignored-in-object-explorer

    OzBobWa commented  · 
    OzBobWa commented  · 
  19. 280 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    16 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa commented  · 

    There is a SSMS bug when importing Settings to get a Dark Theme.
    Please upvote this to get it fixed: https://feedback.azure.com/forums/908035-sql-server/suggestions/35057257-dark-theme-ignored-in-object-explorer

    OzBobWa commented  · 
  20. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    OzBobWa supported this idea  · 
← Previous 1

Feedback and Knowledge Base