Problem: I ran into this error when executing a script on a SQL database. I could attach or deattach the database, and SQL Management Studio showed the database was fine.
Fix: it turns out the database has ‘-‘ in the name, e.g. database_2008-10-01. Renaming the database by removing ‘-‘ fixed the problem.
Do not use ‘-‘ in SQL database name.
No comments:
Post a Comment