Report on SQL Server objects

Hi,
We have a large database for which we need to provide support. But there is
no documentation on number of tables, stored procedures etc.
Is there any easy way to find out number of objects in a SQL Server database
at all?
Can someone let me know please?
Many thanks,
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
I know about the existence of Summary where we can see the list of objects.
Ideally I am looking for a way to document all objects in something like
spread sheets ...
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
|||On Feb 9, 7:58 pm, Harish Mohanbabu <Axa...@.online.nospam> wrote:
> I know about the existence of Summary where we can see the list of objects.
> Ideally I am looking for a way to document all objects in something like
> spread sheets ...
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]http://www.harishm.com/
Use ''DB''
select * from sysobjects where xtype not in ('s') and name not like 'dt
%'
copy the result on excel spreadsheet.
NJ

Report on SQL Server objects

Hi,
We have a large database for which we need to provide support. But there is
no documentation on number of tables, stored procedures etc.
Is there any easy way to find out number of objects in a SQL Server database
at all?
Can someone let me know please?
Many thanks,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/I know about the existence of Summary where we can see the list of objects.
Ideally I am looking for a way to document all objects in something like
spread sheets ...
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/|||On Feb 9, 7:58 pm, Harish Mohanbabu <Axa...@.online.nospam> wrote:
> I know about the existence of Summary where we can see the list of objects.
> Ideally I am looking for a way to document all objects in something like
> spread sheets ...
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]http://www.harishm.com/
Use ''DB''
select * from sysobjects where xtype not in ('s') and name not like 'dt
%'
copy the result on excel spreadsheet.
NJsql

Report on SQL Server objects

Hi,
We have a large database for which we need to provide support. But there is
no documentation on number of tables, stored procedures etc.
Is there any easy way to find out number of objects in a SQL Server database
at all?
Can someone let me know please?
Many thanks,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/I know about the existence of Summary where we can see the list of objects.
Ideally I am looking for a way to document all objects in something like
spread sheets ...
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/|||On Feb 9, 7:58 pm, Harish Mohanbabu <Axa...@.online.nospam> wrote:
> I know about the existence of Summary where we can see the list of objects
.
> Ideally I am looking for a way to document all objects in something like
> spread sheets ...
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]http://www.harishm.com/
Use ''DB''
select * from sysobjects where xtype not in ('s') and name not like 'dt
%'
copy the result on excel spreadsheet.
NJ

REPORT MANAGER - Hiding Tabs/Links ***

Is there a way to hide Tabs and Links on the REPORT MANAGER interface to
limit user access? If you can provide and example that would be highly
appreciated.Yes, you want to limit access using security. On the properties tab of any
item there should be a security sub-tab which will allow you to set what
users can and can't do with that object. Depending on a users rights only
tabs that a user can use will show up.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Collins" <MikeCollins@.discussions.microsoft.com> wrote in message
news:7F502733-69FE-4C4A-A16B-02E6A3192933@.microsoft.com...
> I'm not an expert on this, but you can limit user access through IIS. Make
> sure anonymous access is not checked in your security in IIS. Then through
> the Report Manager, you can add users (or groups) and give them certain
> access rights.
> "doug" wrote:
> > Is there a way to hide Tabs and Links on the REPORT MANAGER interface to
> > limit user access? If you can provide and example that would be highly
> > appreciated.