Posted by Erland Sommarskog on 08/10/06 07:11

--[zainy]-- (zainys@gmail.com) writes:
> I am having problems on creating table through Enterprise Manager. It
> gives me Error 1038 i.e. is as follows
>
> Unexpected Error
>
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use
> empty object
> or column names. Use a single space if necessary.

Don't create tables through EM. Use CREATE TABLE instead. That pays off in
the long run.

Apparently you did something you shouldn't have done, but without more
information it's impossible to say.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Flattening Parent Child Hierarchy: Urgent please help
• Prev in forum: Error in Creating table in Sql server 2000
• Thread view: Re: Error in Creating table in Sql server 2000

[Reply to this message]