sql-serverazuressms
Connect to user Azure database from SSMS by default
When logging into my Azure database through SSMS, how can I make my user database the default? It currently logs me into the Master database, which requires me to manually change the database.
This error occurs when I try to switch databases with T-SQL: 'use myDatabase'.
Solution
@StinkySocks said: The first picture does work. You need to click the 'Browse Server...' option, then select the database. I do not believe it works if you simply type in your database in the box without using the "browse" option first.
- Default parameter in SQL where clause
- How can I filter words in SQL using a function?
- Getting the second occurrence from charindex function in sql server
- Connecting to a SQL Server database running in a Docker container from another docker container
- How to connect to SQL Server docker container from another container?
- Unable to enable Microsoft Change Data Capture (CDC) sp_cdc_enable_db
- Crosstab in SQL Server with a column that may have no data
- Can't remove single Quote in SQL
- IIS Regional Settings
- MS Access error "ODBC--call failed. Invalid character value for cast specification (#0)"
- Multiple select queries with union, flatten to single row
- How to access my database from another server
- Highlight Duplicate Values in a NetSuite Saved Search
- Unique constraint on multiple columns in a table variable
- Get size of all tables in database
- SSRS- How can I eliminate page breaks within an email body?
- Performing a bitwise sum
- Creating a balance statement
- One Index, Two Indexers, Populate Array
- SQL Selecting if "active" = true
- Automatically deleting old log entries with the Serilog mssqlserver sink?
- What does the SQL Server Error "String Data, Right Truncation" mean and how do I fix it?
- A mathematical way to divide overlapping time ranges into hours
- How can I efficiently convert a bigint into a base 2 string and count the 1s?
- sqlBulkCopy WriteToServer throwing an error on computed fields (even if they are not included in the INSERT statement)
- SSRS Date Parameter and second parameter
- Query to count time difference when its greater than a minimum time
- Create Table Computed Value
- How to place FK constraint so that deleting a single FK record DOES NOT delete the primary record
- How to read each row and value with SqlCommand in C#?