New Database Error Message

I am relatively new to SQL Server. I created a new
database with (and without) the new database wizard.
When I get to the end of the wizard, I get an error
message [error 1038] indicating that I cannot use empty
object or column and should use a space instead. The new
database gets created and is listed in the tree diagram.
I get a similar error message when I open the new
database and try and add a new table to it. I am running
on the local server. Anyone have any ideas?
Thanks.
Joe
I have never run across this error but do you have spaces in any of your
object names by any chance?
Andrew J. Kelly SQL MVP
"Joe" <josephmicheli@.sbcglobal.net> wrote in message
news:740101c494d6$7bc4be20$a601280a@.phx.gbl...
> I am relatively new to SQL Server. I created a new
> database with (and without) the new database wizard.
> When I get to the end of the wizard, I get an error
> message [error 1038] indicating that I cannot use empty
> object or column and should use a space instead. The new
> database gets created and is listed in the tree diagram.
> I get a similar error message when I open the new
> database and try and add a new table to it. I am running
> on the local server. Anyone have any ideas?
> Thanks.
> Joe
|||The the new database I created was a default created by
the wizard. The wizard did not allow me to add/modify any
of the objects in the database. I believe it uses
the "model" database that comes with SQL Server 2000. When
I compared the new one to the model, the number of tables
were the same (19) and the table names looked to be the
same.
>--Original Message--
>I have never run across this error but do you have spaces
in any of your[vbcol=seagreen]
>object names by any chance?
>--
>Andrew J. Kelly SQL MVP
>
>"Joe" <josephmicheli@.sbcglobal.net> wrote in message
>news:740101c494d6$7bc4be20$a601280a@.phx.gbl...
new[vbcol=seagreen]
running
>
>.
>
|||I never use the wizard so I wasn't sure what was going on and if maybe you
tried to use spaces in the DB name. You might want to get in the habit of
using commands such as CREATE DATABASE instead. This allows for much more
control and better information if an error occurs. To create a database is
pretty easy. Check out CREATE DATABASE in BooksOnLine for samples and
details.
Andrew J. Kelly SQL MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:089101c494df$69d374a0$a401280a@.phx.gbl...[vbcol=seagreen]
> The the new database I created was a default created by
> the wizard. The wizard did not allow me to add/modify any
> of the objects in the database. I believe it uses
> the "model" database that comes with SQL Server 2000. When
> I compared the new one to the model, the number of tables
> were the same (19) and the table names looked to be the
> same.
> in any of your
> new
> running