Please do not post the same question independently to multiple newsgroups.
See my reply in .server.
SQL Server MVP
Quote:> Is possible create a new table in master database with the
> flag 'System'?
> Rui Oliveira
(this is version 2000 SP1)
When creating a new table, either thru T-SQL, the EM, or importing from
another server, the table is flagged as a "System" type, rather than a
"User" type. Thus, the table cannot then be edited/renamed/deleted. Even
something as simple as the following:
CREATE TABLE [dbo].[Test_Table] (
[id] [int] IDENTITY (1, 1) NOT NULL,
Results in "Test_Table" being created as a system table. The only change to
the server I can recall being made in months is that the recovery model was
switched from simple to bulk-logged. Other than that, I do not believe
anything has changed on this system.
Ideas and suggestions appreciated.