473,230 Members | 1,374 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 software developers and data experts.

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 2966
--[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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Kevin | last post by:
Hi All, I am new to MS SQL Server.I am using MS SQL 2000.I have a problem in creating a table by using Select command.I have table called "test" and i want to create another table with the same...
5
by: Tony Wright | last post by:
Hi, I am having a problem installing an msi for a web site. The error message I am getting is: "The specified path 'http://mipdev05/features/Fas2' is unavailable. The Internet Information...
31
by: Neil | last post by:
I have an Access 2000 MDB with ODBC linked tables to a SQL Server 7 back end. I currently have a selections table in the front end file which the users use to make selections of records. The table...
7
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....
0
by: Peter D. Dunlap | last post by:
I have a number of web sites on my 2003 server, each of the independent sites (i.e., not subdirectories of the localhost site). The way I have always set these up in the past is: 1. Create a...
4
by: J. Jespersen | last post by:
Hi all, Have been using SqlDataSources for a while now. Reinstalled machine last week, now running Server 2003. Installed both SqlServer 2000 and 2005 with instance-names "sql2000" and...
1
by: RSH | last post by:
Im trying to create a stored procedure of the following code. I want to set it so that I have to send the first 4 variables (@DB, @BackUpFile,@TestDB,@RestoreFile). I am having trouble when i try...
5
by: snicks | last post by:
I'm trying to exec a program external to my ASP.NET app using the following code. The external app is a VB.NET application. Dim sPPTOut As String sPPTOut = MDEPDirStr + sID + ".ppt" Dim p As...
2
by: Charles Wilt | last post by:
I have a IBM iSeries (aka AS-400) running v5r3 of OS/400 that I access via a linked server from SQL Server 2000. The following select works fine: select * from...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.