sqlcmd – Service Artem is running…

FIX ERROR – MS SQL: The database ‘YOUR_DB_NAME’ is enabled for database mirroring.

The following error occurred while trying to delete the database in MS SQL: The database ‘YOUR_DB_NAME’ is enabled for database mirroring. Database mirroring must be removed before you drop the database. Solution:

MS SQL – Creating a user with full permissions to the database

Create the user “admin_web” with the username “admin_web“, password “password1234” and provide the owner permissions to the database “artem_services” Create LOGIN: Use necessary database: Create a USER for the previously created LOGIN: Add a USER to the database owners group:

M	T	W	T	F	S	S
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30