Re: sysdiagrams is marked as user table
- From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 3 Nov 2006 20:28:19 +0100
Personally, I think that the diagram objects should be marked as is_ms_shipped = 1, even though they are not installed by default.
I agree...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@xxxxxxxxxxxxxx> wrote in message news:%234rzuV3$GHA.3380@xxxxxxxxxxxxxxxxxxxxxxx
To wit, as long as you don't mark any of your own objects with the same extended properties:
SELECT o.*
FROM sys.objects o
LEFT OUTER JOIN
sys.extended_properties ep
ON o.[object_id] = ep.major_id
AND ep.class_desc = 'OBJECT_OR_COLUMN'
AND ep.[name] = 'microsoft_database_tools_support'
WHERE
o.is_ms_shipped = 0
AND ep.major_id IS NULL;
Personally, I think that the diagram objects should be marked as is_ms_shipped = 1, even though they are not installed by default.
"Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx> wrote in message news:eVlIXsz$GHA.1224@xxxxxxxxxxxxxxxxxxxxxxxDaniel,
SSMS is able to distinguish it as a "pseudo system table" due to an extended property added for this purpose, which you could also use.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
.
- References:
- sysdiagrams is marked as user table
- From: Daniel Stutz
- Re: sysdiagrams is marked as user table
- From: Paul Ibison
- Re: sysdiagrams is marked as user table
- From: Aaron Bertrand [SQL Server MVP]
- sysdiagrams is marked as user table
- Prev by Date: Re: sysdiagrams is marked as user table
- Next by Date: Re: Management Studio startup error: splash screen then nothing
- Previous by thread: Re: sysdiagrams is marked as user table
- Next by thread: Re: sysdiagrams is marked as user table
- Index(es):
Relevant Pages
|
