New answers tagged ssms
1
vote
Accepted
Is there a keyboard shortcut to open a registered server?
If you have the "right-click" key on your keyboard, you can use it, followed by E.
It's often called the "Menu" key, so Menu, E.
If you don't have that key, you can use Shift+F10 ...
- 1,543
1
vote
Unable connect to SQL Server on SSMS and Got error 10054
Error Message
The cause for 10054 errors according to Microsoft is:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL ...
- 17.4k
1
vote
Accepted
How can I copy a database schema from my local Sql Server to Azure SQL Database
As mustaccio mentioned in the comments, it would be easier to just use the tools that Microsoft provides.
The Azure Migrate tool, which can be added from the marketplace, has been getting better and ...
- 1,597
0
votes
Accepted
How do I change the password for a login on Azure SQL Database via SSMS
It's not possible in the GUI of SSMS but you can do so with the following T-SQL script:
ALTER LOGIN david WITH PASSWORD = 'NewPasswordGoesHere';
More examples can be found in the docs for the ALTER ...
- 35.1k
2
votes
Accepted
Problem connecting two instances of the same RDB table via an intermediary table
Unless I am missing something SSMS doesn’t permit me to add (drag and drop) copies of tables to the Relationship Diagram like Access does.
If by Relationship Diagram, you mean the Database Diagram ...
- 35.1k
Top 50 recent answers are included