Category: Errors

The following error “Unclosed quotation mark after the character string…” occurs when you miss a quotation mark.

When the single quote is used once, and to close the statement SQL Server is expecting another single quote. For some reason, a user can forget to do it. For example:

BACKUP DATABASE Adventureworks TO DISK = 'diff.bak

Read More

The “Incorrect syntax near…” error appears if some symbol is missed. For example, the user decided to make a full database backup with the following command:

BACKUP DATABASE Adventureworks TO DISK 'full.bak'

Read More

The “Database ‘AdventureWorks’ already exists. Choose a different database name.” error appears if the database with the same name already exists. For example, a user decided to create a new database backup with the following command:

CREATE DATABASE Adventureworks

Read More