Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ujohnc00
Starting Member
5 Posts |
 Posted - 2004-09-17 : 12:43:53
|
| Hi. I think I had posted this in the wrong forum earlier, so let me post it here instead:Hello.I am creating a DTS package that, amongst other thing, creates some tables. For some reason, the tables that are created are of type 'System' instead of type 'User'. I have never encountered this before and would appreciate any guidance. Here is an example of one of the create statements:CREATE TABLE [dbo].[Stations] ([station_id] [int] IDENTITY (1, 1) NOT NULL ,[station_number] [int] NOT NULL ,[station_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY]GOSeems standard enough to me. Why would system tables be create with an SQL CREATE TABLE statement?Thanks for your help,Chris |
|
|
ujohnc00
Starting Member
5 Posts |
Posted - 2004-09-22 : 12:16:12
|
| Nevermind. I found the answer to my problems in a thread on google groups (search for "Why is the IsMsShipped bit set?" in microsoft.public.sqlserver.programming). I still don't know how/why this setting was changed, but running the following command fixes the problem:EXEC master.dbo.sp_MS_upd_sysobj_category 2Apparently, the IsMSShipped bit was being set in the sysobjects status column for all new tables. Not sure why though. I don't think there were changes to the system, so maybe this is a bug?Thanks for your help. |
 |
|
|
|
|
|
CREATE TABLE is creating system tables: HELP