-
table type differ in EM and QA
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
-
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.
-
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
-
Consider those as system tables. Dont mess with those tables.
-
Did you ever install Quest's sql spotlight on your server?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|