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 |
|
sankarg
Starting Member
1 Post |
 Posted - 2006-05-19 : 20:01:22
|
| I have a number of tables in a database that are user tables but appear in EM as system type. A query on sysobjects shows th type and xtype as 'U'. The Status column however is a negative (eg -536868573) value.I don'tknow how they got this way and it appears to have been random. It does not affect the working of the DB or the apps that access it but it would be helpful to get these to be user type again. e.g they are excluded from scripts generated from EM. |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-05-20 : 00:46:06
|
| You aren't talking about the DT_ tables, are you? |
 |
|
|
|
|
|
User talbes marked as system type