Azure Data Studio not acting like SSMS

• mike.podric@gmail.com

  SSC Rookie

  Points: 32

  More actions

  November 16, 2023 at 12:55 am

  #4328508

  I created a schema and a table under that schema.

  I queried that table.

  I wrote a stored procedure that queried that table with a basic select statement.   The script failed on Azure Data Studio but SSMS had no issues.  the same Azure SQL database was used .  The error was that it could not find the table.

  When I created the schema I used the same credentials and created it with "Create Schema test"; it ran successfully.

  Why is my create SP script claiming the table does not exist with Azure Data Studio but running find with SSMS?

   

  thanks.

   

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  November 17, 2023 at 1:10 am

  #4329200

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.