473,323 Members | 1,560 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

simple system table question

Dan
Hi,

Is there a way to hide the system tables created in each SQL server
database (ie. dtproperties, sysindexes). It's not a big deal, but I'd
like to see only the tables I create.
Jul 20 '05 #1
5 1271
Hi

Assuming that you are in EM, then I don't think this is possible, although
you could order by the schema owner or type.

John

"Dan" <da*********@gmail.com> wrote in message
news:b0**************************@posting.google.c om...
Hi,

Is there a way to hide the system tables created in each SQL server
database (ie. dtproperties, sysindexes). It's not a big deal, but I'd
like to see only the tables I create.

Jul 20 '05 #2
On 11 Sep 2004 12:07:03 -0700, Dan wrote:
Hi,

Is there a way to hide the system tables created in each SQL server
database (ie. dtproperties, sysindexes). It's not a big deal, but I'd
like to see only the tables I create.


Hi Dan,

If you're using Enterprise Manager, just right-click the server icon and
select "Edit SQL Server Registration properties ...". Remove the tick
before "Show system databases and system objects" and click "OK".

That's it!

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
Jul 20 '05 #3
My bad!

Must remember to use EM more!

John

"John Bell" <jb************@hotmail.com> wrote in message
news:41**********************@news.easynet.co.uk.. .
Hi

Assuming that you are in EM, then I don't think this is possible, although
you could order by the schema owner or type.

John

"Dan" <da*********@gmail.com> wrote in message
news:b0**************************@posting.google.c om...
Hi,

Is there a way to hide the system tables created in each SQL server
database (ie. dtproperties, sysindexes). It's not a big deal, but I'd
like to see only the tables I create.


Jul 20 '05 #4
Yes and No.

It all depends on what client software you are using.

"Dan" <da*********@gmail.com> wrote in message
news:b0**************************@posting.google.c om...
Hi,

Is there a way to hide the system tables created in each SQL server
database (ie. dtproperties, sysindexes). It's not a big deal, but I'd
like to see only the tables I create.

Jul 20 '05 #5
Dan
Sweet! That did it. Thanks to everyone who replied.

Hugo Kornelis <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message news:<34********************************@4ax.com>. ..
On 11 Sep 2004 12:07:03 -0700, Dan wrote:
Hi,

Is there a way to hide the system tables created in each SQL server
database (ie. dtproperties, sysindexes). It's not a big deal, but I'd
like to see only the tables I create.


Hi Dan,

If you're using Enterprise Manager, just right-click the server icon and
select "Edit SQL Server Registration properties ...". Remove the tick
before "Show system databases and system objects" and click "OK".

That's it!

Best, Hugo

Jul 20 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bob | last post by:
I am sure this has been answered in over whelming detail in this group, however the search results have not turned up any thing I am interested in. I want a simple form generator in PHP that...
30
by: Dimitris | last post by:
Hi folks... As part of an assignment, I have to design and implement a fairly small MYSQL 4.0.17 database for a fictitious travel agency. This database will store data from customers submitting...
3
by: Aamir | last post by:
Hi, Quick Question: How to create a simple XML with US States list and read it into a combo box. Detail: I am very new to Dot Net technology as well as xml. I am building a desktop app in...
8
by: Ross A. Finlayson | last post by:
I'm trying to write some C code, but I want to use C++'s std::vector. Indeed, if the code is compiled as C++, I want the container to actually be std::vector, in this case of a collection of value...
5
by: Will | last post by:
I've got a simple form that collects data from a user and I want to display that data in a sortable grid or table. The nature of this data is rather temporary, so there's no need to persist it to a...
0
by: Pietje puk | last post by:
Hello, Since im quite new to ASP.NET i wanted to ask you folks what the best way is to create a WebForm for modifying 1 field from a record. The manipulation of this field can be done by using...
12
by: dgk | last post by:
I'm planning on writing a fairly small app (VB2005) to be distributed via shareware that needs a single user database. I don't even think that SQL Server Express edition is needed since I think...
2
by: Eniac | last post by:
*argh* ... *pull hairs* I've recently started developing from ASP to ASP.NET The switch was fairly smooth since i had done some VB.net before ... then came...FORMS! :) I find it astounding...
6
by: Jim M | last post by:
I've been distributing a fairly mature, very specific MS Access application to end users in small offices of colleges for several years now. This is a part-time venture and low volume operation-...
3
by: Tomislav Petrovic | last post by:
I have following table and a stored procedure in which I want to select rows from the table whose LOCAL_ID is one of the ids I give it in a_local_ids table which is input parameter and return...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.