CREATE TABLE is creating System tables

Last Post 23 Oct 2007 12:25 PM by muttstrat. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
muttstrat
New Member
New Member

--
23 Oct 2007 10:35 AM
When I create a table on one of my SQL 2000 test servers, the table is created as a System table rather than a User table. It doesn't matter whether I use CREATE TABLE from T-SQL, or SQL EM, or create a table from within DTS. The result is always a System table. Has anyone seen this behavior before? I'm not sure when the change occurred, but this server has not always exhibited this behavior.

muttstrat
New Member
New Member

--
23 Oct 2007 12:25 PM
Enterprise SP3
muttstrat
New Member
New Member

--
24 Oct 2007 07:58 AM
Never mind, the problem is resolved:

--Turn system object marking off
EXEC master.dbo.sp_MS_upd_sysobj_category 2

sandeshsegu
New Member
New Member

--
15 Jul 2008 11:36 PM
quote:

Originally posted by: muttstrat
Never mind, the problem is resolved:

--Turn system object marking off
EXEC master.dbo.sp_MS_upd_sysobj_category 2




Thanks Buddy....
It solved my problem

Thanks
Sandesh S
http://sanssql.blogspot.com/
http://sanssql.googlepages.com/


Acceptable Use Policy
---