Re: Unable to create new table or view

From: Joe (anonymous_at_discussions.microsoft.com)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 06:13:29 -0700

I'm kind of new at this. I'm not sure what you mean by
your question.
>-----Original Message-----
>Joe wrote:
>> I am unable to create a new table or view in any
database
>> in SQL Server 2000. When I try and add a new table or
>> view I get the following message:
>>
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)]- Cannot use
>> empty object or column names. Use a single space if
>> necessary.
>>
>> I am running on my local server. If anyone has any
>> ideas, please advise. I am at the end of my rope on
this
>> one. Thanks.
>>
>> Joe
>
>Can you post the DDL?
>
>--
>David G.
>.
>

Relevant Pages

  • Re: DAO vs ADO
    ... In the past I have had my differences with Joe as he comes from the SQL side ... I am not sure if SQL Server 2005 has blown it or not, ... Access is a wonderful front end development tool for database developers ... maybe we could let all the programmers go and use whatever the latest ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... In the past I have had my differences with Joe as he comes from the SQL side ... I am not sure if SQL Server 2005 has blown it or not, ... Access is a wonderful front end development tool for database developers ... maybe we could let all the programmers go and use whatever the latest ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Unable to create new table or view
    ... Joe wrote: ... >> running the buggy retail release of SQL Server. ... >> David G. ... Please report the exact error message you are seeing plus any ...
    (microsoft.public.sqlserver.tools)
  • Re: sql server 2005 security and schemas: an example please?
    ... First of all what vesrion of SQL Server are you using? ... permission only for schema that belongs to them. ... CREATE USER Joe FOR LOGIN Joe ... CREATE USER Paul FOR LOGIN Paul WITH DEFAULT_SCHEMA = Paul ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to create new table or view
    ... SQL Server MVP ... Columnist, SQL Server Professional ... "Joe" wrote in message ... >Can you post the DDL? ...
    (microsoft.public.sqlserver.tools)