Creating database fails with message: Incorrect Syntax near "!"

0 Likes

Problem:

Creating database fails with message: Incorrect Syntax near "!"

Resolution:

  • Product Name: StarTeam
  • Product Version: N/A
  • Product Component: SQL Server
  • Platform/OS Version: Windows

Description:

Creation of new StarTeam configuration fails at the last step with the following error message when StarTeam Server Administration is creating the new database:
Incorrect syntax near "!"



Answer/Solution:

Above error is due to using special character "!" in the database name or password.

You can consult SQL Server documentation about what special characters are not permitted in database name or password.



Author:Gurvinder Dhillon

Old KB# 28189
Comment List
Related
Recommended