July 4, 2004 at 1:08 am
I recently discovered that while the replication system tables (eg sysarticles, syssubscriptions, syspublications etc) are marked as system tables in enterprise manager, if I query the sysobjects table or ose the objectproperties function then they are marked as user tables.
Does anyone know if there's an way in TSQL to see that these are system tables?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 5, 2004 at 7:41 am
You shoudn't create tables begining with sys, so all the tables with that word, should be also system tables.
July 5, 2004 at 8:09 am
Unfortunatly I have no control over table names. Amoung the tables I have in this db are a couple called System_
I can do some sql to find all tables that are sys and not system but I was really hoping there's an easier way, since Enterprise manager does recognises those tables as system.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply