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 : 11:16:20
|
| 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.Thanks for your help,Chris |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-18 : 17:23:46
|
| Good question. Use the profiler to see what it's doing.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ujohnc00
Starting Member
5 Posts |
Posted - 2004-09-22 : 11:36:20
|
| I am not familiar with using SQL Profiler. How should I use it to find out why system tables are being created?Thanks for your response. |
|
|
|
ujohnc00
Starting Member
5 Posts |
Posted - 2004-09-22 : 12:15:50
|
| 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. |
|
|
|
|
|
|
Created tables are of type 'System'; why?