Very Computer

I am trying to create a table on a database using the following
script:

if exists (select * from sysobjects where id =
object_id(N'[dbo].[tblResponsesBackup]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[tblResponsesBackup]
GO

CREATE TABLE [dbo].[tblResponsesBackup] (
        [fldResponseID]  [uniqueidentifier] NULL ,
        [fldCSID] [uniqueidentifier] NULL ,
        [fldDate] [smalldatetime] NULL ,
        [fldResponse] [ntext] NULL ,
        [fldAttachedFile] [nvarchar] (255) NULL ,
        [fldFileAttached] [smallint] NULL ,
        [fldDocID] [int] NULL ,
        [fldUserID] [uniqueidentifier] NULL ,
        [fldUser] [nvarchar] (3) NULL ,
        [fldLastUpdate] [smalldatetime] NULL ,
        [fldUpdateBy] [uniqueidentifier] NULL
)
GO

If I run it against an ordinary database it works fine and the table
is visible.  If I run it against the database where I *actually* want
it, it appears to run fine but the table is not visible.  If I try to
create the table manually, the system informs me "Table
tblResponsesBackup already exists".  Not in my database window it
doesn't.

The difference is that the database where I want to create the table
has some tables involved in merge replication.

How to make the table visible?  Any ideas, anyone?

TIA

Edward

Have you tried to access it with a two-part name - like
SELECT * FROM dbo.tblResponsesBackup ?

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
Please join me at PASS North America in Denver - the first and only
user conference dedicated to SQL Server.
http://www.sqlpass.org/events/denverjan/index.cfm

Quote:> I am trying to create a table on a database using the following
> script:

> if exists (select * from sysobjects where id =
> object_id(N'[dbo].[tblResponsesBackup]') and OBJECTPROPERTY(id,
> N'IsUserTable') = 1)
> drop table [dbo].[tblResponsesBackup]
> GO

> CREATE TABLE [dbo].[tblResponsesBackup] (
> [fldResponseID]  [uniqueidentifier] NULL ,
> [fldCSID] [uniqueidentifier] NULL ,
> [fldDate] [smalldatetime] NULL ,
> [fldResponse] [ntext] NULL ,
> [fldAttachedFile] [nvarchar] (255) NULL ,
> [fldFileAttached] [smallint] NULL ,
> [fldDocID] [int] NULL ,
> [fldUserID] [uniqueidentifier] NULL ,
> [fldUser] [nvarchar] (3) NULL ,
> [fldLastUpdate] [smalldatetime] NULL ,
> [fldUpdateBy] [uniqueidentifier] NULL
> )
> GO

> If I run it against an ordinary database it works fine and the table
> is visible.  If I run it against the database where I *actually* want
> it, it appears to run fine but the table is not visible.  If I try to
> create the table manually, the system informs me "Table
> tblResponsesBackup already exists".  Not in my database window it
> doesn't.

> The difference is that the database where I want to create the table
> has some tables involved in merge replication.

> How to make the table visible?  Any ideas, anyone?

> TIA

> Edward

Edward,

  Any chance tblResponsesBackup exists, but is some kind of object
other than a table?

create view tblResponsesBackup as
select * from pubs..sales
go

if exists (select * from sysobjects where id =
object_id(N'[dbo].[tblResponsesBackup]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[tblResponsesBackup]
GO

CREATE TABLE [dbo].[tblResponsesBackup] (
        [fldResponseID]  [uniqueidentifier] NULL ,
        [fldCSID] [uniqueidentifier] NULL ,
        [fldDate] [smalldatetime] NULL ,
        [fldResponse] [ntext] NULL ,
        [fldAttachedFile] [nvarchar] (255) NULL ,
        [fldFileAttached] [smallint] NULL ,
        [fldDocID] [int] NULL ,
        [fldUserID] [uniqueidentifier] NULL ,
        [fldUser] [nvarchar] (3) NULL ,
        [fldLastUpdate] [smalldatetime] NULL ,
        [fldUpdateBy] [uniqueidentifier] NULL
)
GO

select * from sysobjects where
id=object_id(N'[dbo].[tblResponsesBackup]')

drop view tblResponsesBackup

Steve Kass
Drew University