MSSQL
| Introduction | |
| MS SQL errors | |
| Similar articles |
Mistakes.
MS SQL
Show the list of MS SQL tables on the screen
SELECT TABLE_NAME FROM information_schema.tables select table_name, column_name from information_schema.columns;
MS SQL errors
server management studio error 4064
If you try to connect to the database you get the following error:
Cannot open user default database. Login failed.
Login failed for user ‘UserName’. (Microsoft SQL Server, Error: 4064)
Move in. Options
If in the field Connect to database: worth <default> replace him in the name of your database.
In this example, instead of eth1.ru_db must be a name The database you want to access.
Article author: Andrei Olegovich
| Databases | |
| PostgreSQL | |
| MySQL | |
| MSSQL | |
| SQLite3 | |
| MariaDB | |
| NoSQL databases | |
| SQL in general | |
| Redis | |
| MongoDB | |
| MySQL + PHP | |
| SQLite + Python |