Create a new system table

Is possible create a new table in master database with the
flag 'System'?
Thanks,
Rui OliveiraYes, if you work for Microsoft
For the rest of us NO
You should not mess with system tables and you should not be creating tables on the master database. You will not be able to do either when you move to Yukon so start developing good habits now
Regard
John|||Hi Rui
The following is the limit of what you can do:
create table mysystemtable ( ....)
go
sp_MS_marksystemobject mysystemtable
go
This table will show up as 'system' in Enterprise Manager, but NOT when you
use sp_help in Query Analzyer. You might be able to force it by making
directly updates to sysobjects, but I wouldn't do that on a production
machine.
Can you tell us why you need to do this?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:553e01c40046$09f66570$a001280a@.phx.gbl...
> Is possible create a new table in master database with the
> flag 'System'?
> Thanks,
> Rui Oliveira
>|||Tks
>--Original Message--
>Hi Rui
>The following is the limit of what you can do:
>create table mysystemtable ( ....)
>go
>sp_MS_marksystemobject mysystemtable
>go
>This table will show up as 'system' in Enterprise
Manager, but NOT when you
>use sp_help in Query Analzyer. You might be able to force
it by making
>directly updates to sysobjects, but I wouldn't do that on
a production
>machine.
>Can you tell us why you need to do this?
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"Rui Oliveira" <anonymous@.discussions.microsoft.com>
wrote in message
>news:553e01c40046$09f66570$a001280a@.phx.gbl...
>> Is possible create a new table in master database with
the
>> flag 'System'?
>> Thanks,
>> Rui Oliveira
>
>.
>