fix DBCC CHECKCATALOG errors

How to fix system tables integrity errors? DBCC CHECKCATALOG points
that exists objects (in sys.columns) without depend views. In SQL 2000 I can
edit direct sysobject table. How delete orphaned objects in SQL 2005? Only
way is copy data to new database?I wouldn't think editing sysobjects is a real good idea, unless you're very
(very) sure.
However, since CHECKCATALOG is part of CHECKDB, I would assume you would
used CHECKDB to repair any problems.
"Waldemar Grzywiñski" <waldemarg@.autograf.pl> wrote in message
news:evNoNT%23JIHA.5684@.TK2MSFTNGP06.phx.gbl...
> How to fix system tables integrity errors? DBCC CHECKCATALOG points
> that exists objects (in sys.columns) without depend views. In SQL 2000 I
> can edit direct sysobject table. How delete orphaned objects in SQL 2005?
> Only way is copy data to new database?
>

fix DBCC CHECKCATALOG errors

How to fix system tables integrity errors? DBCC CHECKCATALOG points
that exists objects (in sys.columns) without depend views. In SQL 2000 I can
edit direct sysobject table. How delete orphaned objects in SQL 2005? Only
way is copy data to new database?I wouldn't think editing sysobjects is a real good idea, unless you're very
(very) sure.
However, since CHECKCATALOG is part of CHECKDB, I would assume you would
used CHECKDB to repair any problems.
"Waldemar Grzywiski" <waldemarg@.autograf.pl> wrote in message
news:evNoNT%23JIHA.5684@.TK2MSFTNGP06.phx.gbl...
> How to fix system tables integrity errors? DBCC CHECKCATALOG points
> that exists objects (in sys.columns) without depend views. In SQL 2000 I
> can edit direct sysobject table. How delete orphaned objects in SQL 2005?
> Only way is copy data to new database?
>

fitting a report into a single page

hello guys,

i am making a report which views atleast 20 columns..and on the default font size it is being rendered which is in 11 it is impossible to print it in a single page..

i am just wondering if it is possible if during the exporting to pdf, is it possible to fit it in a single page by shrinking its contents into a size that will fit the page..

any help will be highly appreciated..

thanks in advance!

Yes. Simply define your page large enough to contain all of the columns. Then export to PDF and print using 'fit to page' option. Warning, the print may be VERY small, but it will scale and be readable on a high quality printer. Remember to increase the length of your page in ratio with the width.|||

ok ill try that one..so that means there is no way you can do it in the reporting services..it is manually done in the acrobat during printing phase isn't it?

anyway thanks for the reply..it really helps!

fitting a report into a single page

hello guys,

i am making a report which views atleast 20 columns..and on the default font size it is being rendered which is in 11 it is impossible to print it in a single page..

i am just wondering if it is possible if during the exporting to pdf, is it possible to fit it in a single page by shrinking its contents into a size that will fit the page..

any help will be highly appreciated..

thanks in advance!

Yes. Simply define your page large enough to contain all of the columns. Then export to PDF and print using 'fit to page' option. Warning, the print may be VERY small, but it will scale and be readable on a high quality printer. Remember to increase the length of your page in ratio with the width.|||

ok ill try that one..so that means there is no way you can do it in the reporting services..it is manually done in the acrobat during printing phase isn't it?

anyway thanks for the reply..it really helps!