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