Failed to execute the T-SQL request on Azure Cloud Shell

[PascalBurume]

Describe the bug

Failed to execute the T-SQL request while creating a table on the database 'Logistics'

What happened?

While executing my request on the Azure Cloud Shell portal, I encountered an issue during the "Connect to your database" step. The third request failed to create a table in the "Logistics" database, despite the previous steps working perfectly. Additionally, upon reviewing the explorer in the Azure portal, I noticed that the "Drivers" table was missing. Furthermore, I am unable to perform any select or insert operations.

What did you expect to happen?

I expected that when executing my request on the Azure Cloud Shell portal, the "Connect to your database" step would successfully create a table in the "Logistics" database, following the previously completed steps. Additionally, I anticipated seeing the "Drivers" table present in the explorer of the Azure portal or Azure Data Studio and being able to perform select and insert operations without any issues.

How would you reproduce the bug?

1. Access the Azure Cloud Shell portal.

2. Initiate the process to connect to the database.

3. Execute the necessary requests to create tables in the "Logistics" database, ensuring that the first two requests are successful.

4. Proceed to execute the third request to create a table in the "Logistics" database.

5. After executing the requests, navigate to the explorer in the Azure portal and verify the presence of the "Drivers" table.

6. Attempt to perform select or insert operations on the database.

7. Observe the failure of the third request to create the table, the absence of the "Drivers" table in the explorer, and the inability to select or insert data.

Did this happen via Desktop and/or Smartphone?

Desktop

Operating System

Windows 11

What browsers are you seeing the problem on?

Microsoft Edge

Version

Version 115.0.1880.3 (Official build) dev (64-bit)

Device

Dell Precision 5520

What is your current role?

Gold Student Ambassadors

What technical topic is this bug related to?

Data - Microsoft Fabric, Azure Synapse Analytics, Power BI, Notebooks, Data Lake, CosmosDB, Azure SQL​

Relevant log output

No response

### Tasks
- [ ] Azure SQL Database Bug Bash

[github-actions[bot]]

Thank you for submitting this issue! The team will review your issue, tag with the appropriate tags, and comment with any additional questions on information needed. :sparkles:

[paladique]

@PascalBurume thanks so much for your issue. Can you also share the learn module or documentation you were using? Thank you!

[PascalBurume]

This the link of the module: https://learn.microsoft.com/en-us/training/modules/provision-azure-sql-db/4-connect-add-data

[PascalBurume]

This the link of the module: https://learn.microsoft.com/en-us/training/modules/provision-azure-sql-db/4-connect-add-data

[hassou]

@PascalBurume You should type GO, for the SQL to execute. It's mentioned in the What is Azure Cloud Shell? tip that you may need to make sure to run the GO command

[hassou]

Perhaps, they should move the tip just before starting to use T-SQL for more convenience

[paladique]

@PascalBurume can you confirm that this was the issue when you have a moment? Thanks!

[PascalBurume]

Yes, I was only that issue