Are you logged in as 'sa' ?
Or another user. Use the owner. Reference
Is it possible it exists in another schema/login that is....
-----Original Message-----
From: Smith Dano
[mailto:mssqldba-ezmlmshield-x27527021.[Email address protected]
Sent: Monday, March 28, 2005 6:26 PM
To: LazyDBA Discussion
Subject: RE: Invisible table
Importance: Low
Select db_id() on it and see where that leads..
-----Original Message-----
From: Chip Smith
[mailto:mssqldba-ezmlmshield-x93033949.[Email address protected]
Sent: Monday, March 28, 2005 6:03 PM
To: LazyDBA Discussion
Subject: RE: Invisible table
Importance: Low
Looked there also. Simply cannot find it in any tables or db's.... Not a
view, table or index. No functions or procs by this name. Baffled.
-----Original Message-----
From: Trevor Weir
[mailto:mssqldba-ezmlmshield-x8217777.[Email address protected]
Sent: Monday, March 28, 2005 2:56 PM
To: LazyDBA Discussion
Subject: RE: Invisible table
Does it perhaps exist in sysindexes?
-----Original Message-----
From: Chip Smith
[mailto:mssqldba-ezmlmshield-x27091346.[Email address protected]
Sent: Monday, March 28, 2005 2:26 PM
To: LazyDBA Discussion
Subject: Invisible table
Mornin Guru's...
Anyone seen anything like this before? Is this from stale stats or
something?
use master
CREATE TABLE [master]..[tblList] (
[name] [sysname] NOT NULL ,
[id] [int] NOT NULL ,
[Owner] [sysname] NOT NULL
) ON [PRIMARY]
GO
Server: Msg 2714, Level 16, State 6, Line 1
There is already an object named 'tblList' in the database.
drop table master..tblList
go
Server: Msg 3701, Level 11, State 5, Line 3
Cannot drop the table 'master..tbllist', because it does not
exist
in the system catalog.
Cannot find the offending table in sysobjects or anywhere else. Any idea
may
help...
Thanks!
-- chip
-----Original Message-----
From: Dylan Jones
[mailto:mssqldba-ezmlmshield-x75500436.[Email address protected]
Sent: Monday, March 28, 2005 10:40 AM
To: LazyDBA Discussion
Subject: sp_trace_create
Hi Gurus,
I am using sp_trace_create to create a file containing trace data. When
I run it the file is created as specified in the directory I have
chosen with the name I have supplied. Unfortunately, an "unknown
error" is returned and the file size remains at 0 bytes. Has anyone
seen this issue?
Regards,
Dylan
Get the latest news on SurfControl and our products,
subscribe to our monthly e-newsletter, SurfAdvisory at:
http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.as
px
*********************************************************************
The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken
or omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error,
please contact the sender.
*********************************************************************
SurfControl Inc.
5550 Scotts Valley Drive
Scotts Valley, California 95066
831-440-2500
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page