469,160 Members | 2,083 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,160 developers. It's quick & easy.

Error in Creating table in Sql server 2000

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.

Aug 10 '06 #1
3 2824
--[zainy]-- (za****@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, es****@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
Aug 10 '06 #2

Erland Sommarskog wrote:
--[zainy]-- (za****@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, es****@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....

Aug 11 '06 #3
--[zainy]-- (za****@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, es****@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
Aug 11 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Tony Wright | last post: by
31 posts views Thread by Neil | last post: by
7 posts views Thread by p | last post: by
reply views Thread by Peter D. Dunlap | last post: by
4 posts views Thread by J. Jespersen | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.