Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
infodemers
Posting Yak Master
183 Posts |
 Posted - 2009-03-03 : 20:58:24
|
Hi everyone,Could someone tell me how I could display my database objects in a web page with the following details.Quick LinksDescription Object Types Properties Files Description Document Author Created June 12, 2008 Object Types - Tables
- Views
- Stored Procedures
- Table-valued Functions
- Scalar-valued Functions
PropertiesProperty Value SQL Server Version SQL Server 2005 Compatability Level SQL Server 2005 FilesName File Group Size File Name MYBase PRIMARY 11.59 GB g:\mssql.2\mssql\data\MYBase .mdf MYBase _log 10.31 GB h:\mssql.2\mssql\data\MYBase _log.ldf MYBase _Archive_Readonly Historical_Readonly 20.79 GB I:\MYBase \Database_ArchiveFileGroup\MYBase _Archive_Readonly.ndf Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
subhash chandra
Starting Member
40 Posts |
Posted - 2009-03-04 : 14:24:52
|
| You are just placing the query result from sys.databases, sys.objects and objectproperty function in your custom interface.Using the SSRS serive, such web pages can easily be created. I suppose SSRS has more user friendly tools like Report builder that makes much easy to display query data on web pages. |
 |
|
|
infodemers
Posting Yak Master
183 Posts |
Posted - 2009-03-10 : 10:34:17
|
I thank you very much Subhash! I will give it a try.quote:
Originally posted by subhash chandra
You are just placing the query result from sys.databases, sys.objects and objectproperty function in your custom interface.Using the SSRS serive, such web pages can easily be created. I suppose SSRS has more user friendly tools like Report builder that makes much easy to display query data on web pages.
|
|
|
|
|
|
|
Display Database Objects