"JP" <J*@discussions.microsoft.com> wrote in message
news:9613EB90-46FE-49A7-A662-2540FC10B8EC@microsoft.com...
> Im trying to access the system tables for SQL 2005. I understand I can no
> longer access the tables directly, and I’m fine with that. But I cannot
> see
> the System Procedures folder or System Databases folder that several sites
> talk about in order to get to all the processes MS created for reading the
> system tables.
>
> I am admin on this box, so why can’t I see any of these views? I don’t
> even
> see the folders themselves in the tree structure.
>
> --
> JP
> .NET Software Develper

"Aaron Bertrand [SQL Server MVP]" wrote:

> You need to expand the "Programmability" folder first.
>
>
> "JP" <J*@discussions.microsoft.com> wrote in message
> news:9613EB90-46FE-49A7-A662-2540FC10B8EC@microsoft.com...
> > Im trying to access the system tables for SQL 2005. I understand I can no
> > longer access the tables directly, and I’m fine with that. But I cannot
> > see
> > the System Procedures folder or System Databases folder that several sites
> > talk about in order to get to all the processes MS created for reading the
> > system tables.
> >
> > I am admin on this box, so why can’t I see any of these views? I don’t
> > even
> > see the folders themselves in the tree structure.
> >
> > --
> > JP
> > .NET Software Develper
>
>
>

"JP" <J*@discussions.microsoft.com> wrote in message
news:D227E564-0C81-4301-8A4F-B9CA6CD892CD@microsoft.com...
> Thanks for your replay. Yes, I see
>
> Stored Procedures
> Functions
> Database Tiggers
> Assemblies
> Types
> Rules
> Defaults
>
> But even if I expand the Stored Procedures out further, all I get is the
> ones I created, the System Procedures folder is not even there
>
> jp
>
> --
> JP
> .NET Software Developer
>
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
>> You need to expand the "Programmability" folder first.
>>
>>
>> "JP" <J*@discussions.microsoft.com> wrote in message
>> news:9613EB90-46FE-49A7-A662-2540FC10B8EC@microsoft.com...
>> > Im trying to access the system tables for SQL 2005. I understand I can
>> > no
>> > longer access the tables directly, and Iâ?Tm fine with that. But I
>> > cannot
>> > see
>> > the System Procedures folder or System Databases folder that several
>> > sites
>> > talk about in order to get to all the processes MS created for reading
>> > the
>> > system tables.
>> >
>> > I am admin on this box, so why canâ?Tt I see any of these views? I
>> > donâ?Tt
>> > even
>> > see the folders themselves in the tree structure.
>> >
>> > --
>> > JP
>> > .NET Software Develper
>>
>>
>>

"Kalen Delaney" wrote:

> JP
>
> The tools for seeing the metadata are primarily VIEWS.
> Expand any database, and choose the Views folder, then open System Views.
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
>
>
> "JP" <J*@discussions.microsoft.com> wrote in message
> news:D227E564-0C81-4301-8A4F-B9CA6CD892CD@microsoft.com...
> > Thanks for your replay. Yes, I see
> >
> > Stored Procedures
> > Functions
> > Database Tiggers
> > Assemblies
> > Types
> > Rules
> > Defaults
> >
> > But even if I expand the Stored Procedures out further, all I get is the
> > ones I created, the System Procedures folder is not even there
> >
> > jp
> >
> > --
> > JP
> > .NET Software Developer
> >
> >
> > "Aaron Bertrand [SQL Server MVP]" wrote:
> >
> >> You need to expand the "Programmability" folder first.
> >>
> >>
> >> "JP" <J*@discussions.microsoft.com> wrote in message
> >> news:9613EB90-46FE-49A7-A662-2540FC10B8EC@microsoft.com...
> >> > Im trying to access the system tables for SQL 2005. I understand I can
> >> > no
> >> > longer access the tables directly, and Iâ?Tm fine with that. But I
> >> > cannot
> >> > see
> >> > the System Procedures folder or System Databases folder that several
> >> > sites
> >> > talk about in order to get to all the processes MS created for reading
> >> > the
> >> > system tables.
> >> >
> >> > I am admin on this box, so why canâ?Tt I see any of these views? I
> >> > donâ?Tt
> >> > even
> >> > see the folders themselves in the tree structure.
> >> >
> >> > --
> >> > JP
> >> > .NET Software Develper
> >>
> >>
> >>
>
>
>

"Aaron Bertrand [SQL Server MVP]" wrote:

> > "system" in the database even though I am sysadmin on the box.
>
> Are you sure?
>
> -- connect as a windows administrator, not a SQL login
> -- enter the SQL login name here:
>
> DECLARE @LoginName SYSNAME;
> SET @LoginName = N'<enter login name here>';
>
> DECLARE @PrincipalID INT;
> SELECT @PrincipalID = principal_id
> FROM master.sys.server_principals
> WHERE name = @LoginName;
>
> -- does this return any rows?
> SELECT *
> FROM master.sys.server_role_members m
> INNER JOIN master.sys.server_principals r
> ON r.principal_id = m.role_principal_id
> WHERE m.member_principal_id = @PrincipalID
> AND r.name = 'sysadmin';
>
> -- if so, how about this?
> SELECT *
> FROM master.sys.database_permissions
> WHERE grantee_principal_id = @PrincipalID
> AND state_desc IN ('DENY', 'REVOKE');
>
>
>

"Aaron Bertrand [SQL Server MVP]" wrote:

> > Logged in as SA.
>
> Great, now can you try logging in as a /*****windows administrator*****/
> instead of using the sa account, and see if your results are any different.
>
>
>

"Roy Harvey" wrote:

> On Tue, 12 Sep 2006 08:53:02 -0700, JP <J*@discussions.microsoft.com>
> wrote:
>
> >Nope still cant see. :(
>
> The information below is from the Books on Line.  I assume you need to
> reverse the process.
>
> Roy Harvey
> Beacon Falls, CT
>
> =============================
> The Databases node of Object Explorer contains system objects such as
> the system databases. Use the Tools/Options pages to hide the system
> objects. Some system objects, such as system functions and system data
> types, are not affected by this setting.
>
> To hide system objects in Object Explorer
> On the Tools menu, click Options.
>
> On the Environment/General page, select Hide system objects in Object
> Explorer, and then click OK.
>
> In the SQL Server Management Studio dialog box, click OK to
> acknowledge that SQL Server Management Studio must be restarted for
> this change to take affect.
>
> Close and reopen SQL Server Management Studio.
> =============================
>

"Roy Harvey" wrote:

> On Tue, 12 Sep 2006 09:21:02 -0700, JP <J*@discussions.microsoft.com>
> wrote:
>
> >ROF LOL it works!!!!!!!!!!!!!!!!
> >
> >Thank you so much.  Why didnt we see that erlier. However, the person in the
> >office next to me unchecked and she still cannot see. So will keep trying
> >with her PC.
>
> Did you stop and restart the program?
>
> Roy
>

:)

"Aaron Bertrand [SQL Server MVP]" wrote:

> > Logged in as SA.
>
> Great, now can you try logging in as a /*****windows administrator*****/
> instead of using the sa account, and see if your results are any different.
>
>
>

"JP" <J*@discussions.microsoft.com> wrote in message
news:F7C78A36-8D71-4EA0-A770-8DBE909F94CB@microsoft.com...
> Aaron,
> Thank you for the time you spent trying to help me solve this problem.
>
> :)
>
>
> --
> JP
> .NET Software Developer
>
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
>> > Logged in as SA.
>>
>> Great, now can you try logging in as a /*****windows administrator*****/
>> instead of using the sa account, and see if your results are any
>> different.
>>
>>
>>