You are here: Re: Error in Creating table in Sql server 2000 « MsSQL Server « IT news, forums, messages
Re: Error in Creating table in Sql server 2000

Posted by --[zainy]-- on 08/11/06 17:19

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/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/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....

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация