Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [azure-data-studio]

Azure Data Studio is a cross-platform database client from Microsoft that enables working with SQL Server, Azure SQL DB and SQL DW

23 questions
18
votes
2 answers

Azure Data Studio - Intellisense does not detect tables, yet queries work. How do I fix this?

Okay. So I'm breaking some new ground and trying to get into Azure Data Studio. I'm having a problem with intellisense that seems to be a bug with Azure Data Studio but I'm not sure. I have issues with basic queries. Foreign keys, select…
Krausladen
  • 199
  • 1
  • 1
  • 6
6
votes
2 answers

How to generate Entity Relationship (ER) Diagram of a on-premises database using Azure Data Studio (macOS)?

I found a similar question for SQL Server Management Studio. But I use latest Azure Data Studio on macOS. We use on-premises SQL Server (not Azure cloud). How can I use Azure Data Studio to generate an ERD from an existing database?
Sybil
  • 2,578
  • 6
  • 34
  • 61
4
votes
1 answer

Change expired user password on sql server from linux

I have got a colleague (software developer) working on Linux only. He connects to our SQL Server using a sql login with password. Occasionally the password expires and he has to choose a new one. Up to now he then heads over to a colleague with…
Martin Guth
  • 715
  • 1
  • 8
  • 22
3
votes
1 answer

How to Parse a query in Azure Data Studio?

In Sql Server Management Studio, we can click a "Parse" button (or Ctrl+F5) to verify that a SQL statement is syntactically correct (without executing it). How can I do it the same in Azure Data Studio?
Click Ok
  • 167
  • 2
  • 7
2
votes
1 answer

Azure Data Studio - intellisence do not see tables in schema other than dbo

Do you know any way to force intellisence in Azure Data Studio to find tables in custom schemas? As you can see I have tables: dbo.TableC schemaA.TableB When typing a query, only TableC is found by intellisence. I know that full SQL Server…
GrzegorzM
  • 121
  • 4
2
votes
1 answer

Azure Data studio - connection to server in the same network - Error: The received certificate has expired

I am trying to connect to SQL server on my network with Azure Data Studio, and I am getting error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 -…
Marko Skokovic
  • 23
  • 1
  • 3
1
vote
2 answers

Does Azure Data Studio have a debug Menu or option to debug a stored procedure?

I installed SSMS 19 Preview 4 and it doesn't have a Debug Menu or Debugging option. I also learnt that SSMS V17 was the last version with that capability. Then I decided to try Azure Data Studio, but still not able to see debug option. Can someone…
TmzGOAT
  • 21
  • 1
  • 7
1
vote
2 answers

Alternative to SQL Server Management Studio and Azure Data Studio to initially change my password

Background I'm having to connect to a customer's Microsoft SQL Server. I generally don't need to do much in databases besides your average SQL, so using the database features in IntelliJ IDEA have so far been more than sufficient for various…
Ricardo van den Broek
  • 113
  • 5
1
vote
0 answers

Is there a way Azure data studio to find and add local databases under a list automatically?

When I create a database locally in SSMS it does not show up automatically in ADS. I have to add it as a connection each time. Generally I use SSMS but am trying to switch away (or just try for fun) from it to ADS.
Billy Bob
  • 111
  • 2
1
vote
0 answers

Incorrect syntax near 'BULK' for bulk INSERT in Azure Data Studio

I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is the query: BULK INSERT [kf].myTable from…
ITried
  • 111
  • 1
  • 2
0
votes
0 answers

SQL71501: User: [user1] has an unresolved reference to Login [user1]

SQL Server DB Projects - when created generates the SQL Users scripts, which aren't associated with any SQL Logins but only to DB, without the condition 'WITHOUT LOGIN' and so leading Build error as below, SQL71501: User: [user1] has an unresolved…
Meera K
  • 81
  • 7
0
votes
0 answers

Can I merge settings.json files in Azure Data Studio

I want to make a few changes to by settings.json file and use these changes on another installation. Is there a way of merging a simplified version of settings.json (with only some changes) on another machine?
Manngo
  • 3,065
  • 10
  • 38
  • 61
0
votes
1 answer

What are the cellPadding values in Azure Data Studio

I’m trying to get used to Azure Data Studio after using SSMS for some time, and, so far, I think its interface is very unfinished. I want to change the cell padding, which I didn’t like to begin with, but gets worse if I change the font size. The…
Manngo
  • 3,065
  • 10
  • 38
  • 61
0
votes
0 answers

Azure Data Studio Database Project Failure When Applying Schema Compare

I'm using Azure Data Studio. I created a brand new project and updated it from the database. Made a very small change, and attempted to apply back to the database. I receive the error "The source login in not a member of the 'loginmanager' role.…
Sean
  • 1
0
votes
0 answers

Open file Azure Data Studio with CLI and connect

I am trying to start Azure Data Studio(1.46.1) from command line to open a file and connect to server and database. I can get it to work separately: connect with new query azuredatastudio --server servername --database databasename…
Bob Klimes
  • 3,400
  • 1
  • 19
  • 31
1
2