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 |
|
dew_girl
Starting Member
1 Post |
Posted - 2006-06-14 : 09:51:20
|
I don't wich choice should I made to avoid have to see the systems objects, for intance, when I open the tables of any Data Base I have like 50 that I haven´t create, so if any one can help me, I will be gratefull, it might sound like BOBO, but I jist don't know. Thanks informatics |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-14 : 12:38:14
|
| EM->SQL SERVER->EDIT SQL server registration properties-> DE-SELECT sysstem databases and system objects.------------------------I think, therefore I am - Rene Descartes |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-15 : 02:45:14
|
quote: Originally posted by dew_girl I don't wich choice should I made to avoid have to see the systems objects, for intance, when I open the tables of any Data Base I have like 50 that I haven´t create, so if any one can help me, I will be gratefull, it might sound like BOBO, but I jist don't know. Thanks informatics
If you use SQL Server, then use query to exclude system objectsSelect * from sysobjects where xtype<>'s'MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
|
|