<div>
Hi <br />
<br />
Alternatively you can use [ ] &nbsp;brace to overcome these errors 
</div>


Hi

Alternatively you can use [ ]  brace to overcome these errors

<div>
<div class="content wysiwyg-content">
Need an answer fast to this question.<br />
<br />
I created a database with a - (&quot;dash&quot;) in the name. The ultimate sin! If its such a sin it should not allow you to create it. You get no error when you create it which is really stupid if you ask me. <br />
<br />
Help!! Please!! I need to rename the database I want to change the - to an _ which I think is legal. Any ideas on how? I tried ALTER DATABASE MODIFY NAME= , but it gives me an error &quot;error near -&quot;. SQL Server 2000. I even tired a proc, but it got the same error. Has anyone ever done this before???<br />
<br />
Doug<br />

</div>
</div>


Need an answer fast to this question.

I created a database with a - ("dash") in the name. The ultimate sin! If its such a sin it should not allow you to create it. You get no error when you create it which is really stupid if you ask me. 

Help!! Please!! I need to rename the database I want to change the - to an _ which I think is legal. Any ideas on how? I tried ALTER DATABASE MODIFY NAME= , but it gives me an error "error near -". SQL Server 2000. I even tired a proc, but it got the same error. Has anyone ever done this before???

Doug


SQL Server 2000 Rename DB with illegal character

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.