Sunday, February 19, 2012

how to hide system tables?

I just upsized from access to a new dbase and now I have all of these system
tables etc. I believe I was told that I could hide those some how?
I'm using Enterprise Manager
ThanksIn enterprise manager, right-click the server name and choose edit sql
server registration properties, then you'll see an option that reads show
system databases and system objects.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Robert Blackwell" <robbie@.NOspamwowcentral.com> wrote in message
news:O3FGz9tUDHA.392@.TK2MSFTNGP11.phx.gbl...
> I just upsized from access to a new dbase and now I have all of these
system
> tables etc. I believe I was told that I could hide those some how?
> I'm using Enterprise Manager
> Thanks
>|||http://www.aspfaq.com/2010
"Robert Blackwell" <robbie@.NOspamwowcentral.com> wrote in message
news:O3FGz9tUDHA.392@.TK2MSFTNGP11.phx.gbl...
> I just upsized from access to a new dbase and now I have all of these
system
> tables etc. I believe I was told that I could hide those some how?
> I'm using Enterprise Manager
> Thanks
>|||Thanks guys :o)

No comments:

Post a Comment