AA!

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.

--[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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland Sommarskog wrote:
> --[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/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx

When i right click on table Tag(In EM) under my database and select New
Table then it gives me that error...

It works fine on my other PCs which i installed with the same version
of SQL SERVER 2000....
This error persists on 2nd install as well....

--[zainy]-- (zainys@gmail.com) writes:
> When i right click on table Tag(In EM) under my database and select New
> Table then it gives me that error...
>
> It works fine on my other PCs which i installed with the same version
> of SQL SERVER 2000....
> This error persists on 2nd install as well....

Interesting...

And you access the same database from the PCs where it works?

The only tip I can give is that you run a Profiler trace when you click
on New Table, and then try to find out how the failing command looks like.
You should add TSQL:BatchStarting and RPC:Starting to the default events.

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx