MSSQL

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