I come up with nulls from all system tables. All dbs. Not listed in any of
the information_schemas... Object search cannot find it. Its a production
server so I have not yet been able to bounce. Think I'll just change the
code to use another tablename, for now...
-- chip
-----Original Message-----
From: Jari Nieminen
[mailto:mssqldba-ezmlmshield-x87802992.[Email address protected]
Sent: Tuesday, March 29, 2005 3:55 AM
To: LazyDBA Discussion
Subject: RE: Invisible table
It might be something else than a table.
Error message refers to database object.
/J
-----Original Message-----
From: jason_whiffin
[mailto:mssqldba-ezmlmshield-x67199986.[Email address protected]
Sent: 29. maaliskuuta 2005 10:38
To: LazyDBA Discussion
Subject: RE: Invisible table
it'll more than likely exist with another owner re the "dot dot"
search in enterprise manager
rgds
"Trevor Weir "
<mssqldba-ezmlmshield-x8217777.[Email address protected]
To: "LazyDBA Discussion"
om>
<[Email address protected]
cc:
Subject: RE: Invisible table
Monday March 28, 2005 22:56
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.aspx
*********************************************************************
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