access to newly created table.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

access to newly created table.

Author

Topic

chedderslam
Posting Yak Master

223 Posts

Posted - 2009-08-20 : 16:10:42

I have just created a table with the following statement:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Policies_In_Force_Report_dev](
[Policy_Base] [varchar](12) NOT NULL,
[Policy_Suffix] [smallint] NOT NULL,
[Inforce_Date] [datetime] NOT NULL,
[Policy_State] [varchar](2) NULL,
[Program] [char](1) NULL
)
GO
SET ANSI_PADDING OFF

It does not show up in object explorer even when I refresh.

When I rerun the statement, I get this:
There is already an object named 'Policies_In_Force_Report_dev' in the database.

How do I grant myself permission to use it?

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-20 : 16:24:05

It doesn't sound like a permission issue.

Check that you're looking at the same database in the Explorer and query window.
Do you see the table in sysobjects?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources