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. 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.
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)
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.
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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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-...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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
|
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...
|
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...
| |