table type differ in EM and QA

[ravi]

Hi,
I ran this query in master database
and got the following list of tables.
If I see in Enterprise manger those are showing as a system table.
Why is this difference?.
How I can decide those are system or user type table?.

-- Query
select name from sysobjects
where type='U'

-result
spt_monitor
spt_values
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
dtproperties
spt_provider_types
urPhys
spt_datatype_info_ext
MSreplication_options
spt_datatype_info
spt_server_info

[skhanal]

Enterprise Manager sees IsMSShipped property of the object to decide if an object is system or user.

select objectproperty(id,'IsMSShipped') ,name from sysobjects
where type='U'


All these tables will have 1 in the first column.

[ravi]

Skhanal,
What is your conclusion those are system or user table?.
I'm not clear . Please give me more details.
Thanks,


The BOL discribe about "objectproperty(id,'IsMSShipped')"

IsMSShipped - Any An object created during installation of Microsoft® SQL Server™ 2000.
1 = True
0 = False

[MAK]

Consider those as system tables. Dont mess with those tables.

[rmiao]

Did you ever install Quest's sql spotlight on your server?

[ravi]

rmiao,
No I haven't.