how to scale the paper size?

Hi All,
I have a report which is A3 size , when it print out i wanna to fit into A3
size.
Is that possible to do in reporting service?
Cheers
NickThere is a PageSize property on the report (under the Layout tab). Set this
to the appropriate width and height.
"Nick" wrote:
> Hi All,
> I have a report which is A3 size , when it print out i wanna to fit into A3
> size.
> Is that possible to do in reporting service?
> Cheers
> Nick|||Thanks, David,
how about if i wanna pring out to fit into A4 paper.
Cheers
Nick
"David" wrote:
> There is a PageSize property on the report (under the Layout tab). Set this
> to the appropriate width and height.
> "Nick" wrote:
> > Hi All,
> >
> > I have a report which is A3 size , when it print out i wanna to fit into A3
> > size.
> >
> > Is that possible to do in reporting service?
> >
> > Cheers
> >
> > Nick

How to scale down database diagram to fit into a page for SQL 2005?

In sql 2000 enterprise manager, diagram, I can right click and get page setup where I can shrink the size of the diagram to fit page. In the SQL 2005 diagram, How can I adjust the size of the image printed on paper?

Did Microsoft take this useful feature away?

Steve,

Did you ever figure out how to do this? I am having the same problem now. There has got to be a way to re-size this drawing.

Thanks,

Andy

|||

I figured it out and wrote this doc for my development team.

How To Use Diagram In SQL 2005

Stephan Loh

The Database Designer is a visual tool that allows you to design and visualize a database to which you are connected. When designing a database, you can use Database Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it.(Microsoft Book online)

SQL 2005 allows you to create database diagram (ER diagram, or schema diagram).You can also design database by using this diagram.

1. In Microsoft SQL server Management Studio, Object Explorer, double click on the database you want to work with, right click on Database Diagrams.

2. Select New Database Diagram, add tables.

3. To get print view, right click on the page (Not on a table), select View Page Breaks. This allows you to see the diagram by page.

4. To adjust the size of table,in Microsoft SQL server Management Studio, Click on File at top left corner, select Page Setup.In Page Setup, adjust Print Scale to shrink the size of tables.You can also adjust Orientation, and Select paper size.

5. To make the table show all columns, select one or more tables, right click on one of the tables, and select Autosize Selected Tables.

6. To zoom, (4 ways to zoom), I find the best way is to hold down Ctrl Key, turn the wheel on your mouse.

7. To see more than column name in diagram, highlight tables you want to display other information, right click on one of the selected tables, select Table View,You can select Standard or Other options,if you want to see other information, you will need to select Modify Custom, and add information you want to see.After you click OK, you will need to right click on one of the selected tables, select Table View,Custom.

8. To modify column definition, you can directly click on the cell of column definition to modify it.For example, to modify column name, you click on the column name, and type in new name.

9. To modify a table Name (table property), highlight the table, press F4.

10. To modify a single column,highlight the column, press F4.

11. To add a table, right click on the page (not on a table), and select New Table to start design a new table

12. Add a relationship (Foreign Key Constraint), right click on the foreign key table, and select Relationships.Click on the button on the right side of Tables and Columns Specificationto designate primary key table.

13. To print,in order to make sure WYSIWYG, right click on the page (not on a table), select Recalculate Page Breaks.Review your table layout on computer before you print.

|||Thanks! That is excellent.

-Andy

How to scale down database diagram to fit into a page for SQL 2005?

In sql 2000 enterprise manager, diagram, I can right click and get page setup where I can shrink the size of the diagram to fit page. In the SQL 2005 diagram, How can I adjust the size of the image printed on paper?

Did Microsoft take this useful feature away?

Steve,

Did you ever figure out how to do this? I am having the same problem now. There has got to be a way to re-size this drawing.

Thanks,

Andy

|||

I figured it out and wrote this doc for my development team.

How To Use Diagram In SQL 2005

Stephan Loh

The Database Designer is a visual tool that allows you to design and visualize a database to which you are connected. When designing a database, you can use Database Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it.(Microsoft Book online)

SQL 2005 allows you to create database diagram (ER diagram, or schema diagram).You can also design database by using this diagram.

1. In Microsoft SQL server Management Studio, Object Explorer, double click on the database you want to work with, right click on Database Diagrams.

2. Select New Database Diagram, add tables.

3. To get print view, right click on the page (Not on a table), select View Page Breaks. This allows you to see the diagram by page.

4. To adjust the size of table,in Microsoft SQL server Management Studio, Click on File at top left corner, select Page Setup.In Page Setup, adjust Print Scale to shrink the size of tables.You can also adjust Orientation, and Select paper size.

5. To make the table show all columns, select one or more tables, right click on one of the tables, and select Autosize Selected Tables.

6. To zoom, (4 ways to zoom), I find the best way is to hold down Ctrl Key, turn the wheel on your mouse.

7. To see more than column name in diagram, highlight tables you want to display other information, right click on one of the selected tables, select Table View,You can select Standard or Other options,if you want to see other information, you will need to select Modify Custom, and add information you want to see.After you click OK, you will need to right click on one of the selected tables, select Table View,Custom.

8. To modify column definition, you can directly click on the cell of column definition to modify it.For example, to modify column name, you click on the column name, and type in new name.

9. To modify a table Name (table property),highlight the table, press F4.

10. To modify a single column,highlight the column, press F4.

11. To add a table, right click on the page (not on a table), and select New Table to start design a new table

12. Add a relationship (Foreign Key Constraint), right click on the foreign key table,and select Relationships.Click on the button on the right side of Tables and Columns Specificationto designate primary key table.

13. To print,in order to make sure WYSIWYG, right click on the page (not on a table), select Recalculate Page Breaks.Review your table layout on computer before you print.

|||Thanks! That is excellent.

-Andy

How to scale down database diagram to fit into a page for SQL 2005?

In sql 2000 enterprise manager, diagram, I can right click and get page setup where I can shrink the size of the diagram to fit page. In the SQL 2005 diagram, How can I adjust the size of the image printed on paper?

Did Microsoft take this useful feature away?

Steve,

Did you ever figure out how to do this? I am having the same problem now. There has got to be a way to re-size this drawing.

Thanks,

Andy

|||

I figured it out and wrote this doc for my development team.

How To Use Diagram In SQL 2005

Stephan Loh

The Database Designer is a visual tool that allows you to design and visualize a database to which you are connected. When designing a database, you can use Database Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it.(Microsoft Book online)

SQL 2005 allows you to create database diagram (ER diagram, or schema diagram).You can also design database by using this diagram.

1. In Microsoft SQL server Management Studio, Object Explorer, double click on the database you want to work with, right click on Database Diagrams.

2. Select New Database Diagram, add tables.

3. To get print view, right click on the page (Not on a table), select View Page Breaks. This allows you to see the diagram by page.

4. To adjust the size of table,in Microsoft SQL server Management Studio, Click on File at top left corner, select Page Setup.In Page Setup, adjust Print Scale to shrink the size of tables.You can also adjust Orientation, and Select paper size.

5. To make the table show all columns, select one or more tables, right click on one of the tables, and select Autosize Selected Tables.

6. To zoom, (4 ways to zoom), I find the best way is to hold down Ctrl Key, turn the wheel on your mouse.

7. To see more than column name in diagram, highlight tables you want to display other information, right click on one of the selected tables, select Table View,You can select Standard or Other options,if you want to see other information, you will need to select Modify Custom, and add information you want to see.After you click OK, you will need to right click on one of the selected tables, select Table View,Custom.

8. To modify column definition, you can directly click on the cell of column definition to modify it.For example, to modify column name, you click on the column name, and type in new name.

9. To modify a table Name (table property), highlight the table, press F4.

10. To modify a single column,highlight the column, press F4.

11. To add a table, right click on the page (not on a table), and select New Table to start design a new table

12. Add a relationship (Foreign Key Constraint), right click on the foreign key table, and select Relationships.Click on the button on the right side of Tables and Columns Specificationto designate primary key table.

13. To print,in order to make sure WYSIWYG, right click on the page (not on a table), select Recalculate Page Breaks.Review your table layout on computer before you print.

|||Thanks! That is excellent.

-Andy

How to retrieve the (MB) size of all tables in a database

I have a database under SQL2005 that in a 24 hour period has increased from
200MB to 2GB (this is the dbf file size not the log file size) and there are
no obvious reasons for the increase. We have also tried Shrinking both the D
B
and file with little reduction in size. Is there a way to query the database
and find out the sizes of tables etc to help with further investigation?
Looking at the properties of each in Management studio really isn't feasible
due to the number of objects. TIA
AntonyThe sp below will return all the tables in a database, by reserved size
desc (large to small)
Run this sp in the database of concern:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[BigTables]
AS
/ ****************************************
***********************************
***********
*
* BigTables.sql
* Bill Graziano (SQLTeam.com)
* graz@.sqlteam.com
* v1.1
*
****************************************
************************************
**********/
declare @.id int
declare @.type character(2)
declare @.pages int
declare @.dbname sysname
declare @.dbsize dec(15,0)
declare @.bytesperpage dec(15,0)
declare @.pagesperMB dec(15,0)
create table #spt_space
(
objid int null,
rows int null,
reserved dec(15) null,
data dec(15) null,
indexp dec(15) null,
unused dec(15) null
)
set nocount on
-- Create a cursor to loop through the user tables
declare c_tables cursor for
select id
from sysobjects
where xtype = 'U'
open c_tables
fetch next from c_tables
into @.id
while @.@.fetch_status = 0
begin
/* Code from sp_spaceused */
insert into #spt_space (objid, reserved)
select objid = @.id, sum(reserved)
from sysindexes
where indid in (0, 1, 255)
and id = @.id
select @.pages = sum(dpages)
from sysindexes
where indid < 2
and id = @.id
select @.pages = @.pages + isnull(sum(used), 0)
from sysindexes
where indid = 255
and id = @.id
update #spt_space
set data = @.pages
where objid = @.id
/* index: sum(used) where indid in (0, 1, 255) - data */
update #spt_space
set indexp = (select sum(used)
from sysindexes
where indid in (0, 1, 255)
and id = @.id)
- data
where objid = @.id
/* unused: sum(reserved) - sum(used) where indid in (0, 1, 255) */
update #spt_space
set unused = reserved
- (select sum(used)
from sysindexes
where indid in (0, 1, 255)
and id = @.id)
where objid = @.id
update #spt_space
set rows = i.rows
from sysindexes i
where i.indid < 2
and i.id = @.id
and objid = @.id
fetch next from c_tables
into @.id
end
select --top 25
Table_Name = (select left(name,25) from sysobjects where id = objid),
rows = convert(char(11), rows),
reserved_MB = ltrim(str(reserved * d.low / 1048576.,15,0) + ' ' +
'MB'),
data_MB = ltrim(str(data * d.low / 1048576.,15,0) + ' ' + 'MB'),
index_size_MB = ltrim(str(indexp * d.low / 1048576.,15,0) + ' ' +
'MB'),
unused_MB = ltrim(str(unused * d.low / 1048576.,15,0) + ' ' + 'MB')
from #spt_space, master.dbo.spt_values d
where d.number = 1
and d.type = 'E'
order by reserved desc
drop table #spt_space
close c_tables
deallocate c_tables|||Antony wrote:
> I have a database under SQL2005 that in a 24 hour period has increased fro
m
> 200MB to 2GB (this is the dbf file size not the log file size) and there a
re
> no obvious reasons for the increase. We have also tried Shrinking both the
DB
> and file with little reduction in size. Is there a way to query the databa
se
> and find out the sizes of tables etc to help with further investigation?
> Looking at the properties of each in Management studio really isn't feasib
le
> due to the number of objects. TIA
> Antony
There is a known bug with the auto-growth function in SQL 2005. Sounds
like that might be your problem.
http://connect.microsoft.com/SQLSer...=12717
7
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||This might be useful.
CREATE TABLE #Tables
( [name] nvarchar(20),
[rows] char(11),
[reserved] varchar(18),
[data] varchar(18),
[index_size] varchar(18),
[unused] varchar(18)
)
EXECUTE sp_MSForEachTable 'INSERT INTO #Tables EXECUTE sp_spaceused [?]'
SELECT
[name],
[data]
FROM #Tables
DROP TABLE #Tables
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Antony" <info AT webpc DOT biz> wrote in message news:u0L0oEKFHHA.3212@.TK2MSFTNGP02.phx.gbl
..
>I have a database under SQL2005 that in a 24 hour period has increased from
> 200MB to 2GB (this is the dbf file size not the log file size) and there a
re
> no obvious reasons for the increase. We have also tried Shrinking both the
DB
> and file with little reduction in size. Is there a way to query the databa
se
> and find out the sizes of tables etc to help with further investigation?
> Looking at the properties of each in Management studio really isn't feasib
le
> due to the number of objects. TIA
> Antony|||Thanks everyone for the advice. I found the table that was causing the issue
.
Antony
On 11/30/2006 12:04:10 PM, "Antony" wrote:
>I have a database under SQL2005 that in a 24 hour period has increased from
>200MB to 2GB (this is the dbf file size not the log file size) and there ar
e
>no obvious reasons for the increase. We have also tried Shrinking both the
DB
>and file with little reduction in size. Is there a way to query the databas
e
>and find out the sizes of tables etc to help with further investigation?
>Looking at the properties of each in Management studio really isn't feasibl
e
>due to the number of objects. TIA
>Antony

How to retrieve the (MB) size of all tables in a database

I have a database under SQL2005 that in a 24 hour period has increased from
200MB to 2GB (this is the dbf file size not the log file size) and there are
no obvious reasons for the increase. We have also tried Shrinking both the DB
and file with little reduction in size. Is there a way to query the database
and find out the sizes of tables etc to help with further investigation?
Looking at the properties of each in Management studio really isn't feasible
due to the number of objects. TIA
AntonyThe sp below will return all the tables in a database, by reserved size
desc (large to small)
Run this sp in the database of concern:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[BigTables]
AS
/**************************************************************************************
*
* BigTables.sql
* Bill Graziano (SQLTeam.com)
* graz@.sqlteam.com
* v1.1
*
**************************************************************************************/
declare @.id int
declare @.type character(2)
declare @.pages int
declare @.dbname sysname
declare @.dbsize dec(15,0)
declare @.bytesperpage dec(15,0)
declare @.pagesperMB dec(15,0)
create table #spt_space
(
objid int null,
rows int null,
reserved dec(15) null,
data dec(15) null,
indexp dec(15) null,
unused dec(15) null
)
set nocount on
-- Create a cursor to loop through the user tables
declare c_tables cursor for
select id
from sysobjects
where xtype = 'U'
open c_tables
fetch next from c_tables
into @.id
while @.@.fetch_status = 0
begin
/* Code from sp_spaceused */
insert into #spt_space (objid, reserved)
select objid = @.id, sum(reserved)
from sysindexes
where indid in (0, 1, 255)
and id = @.id
select @.pages = sum(dpages)
from sysindexes
where indid < 2
and id = @.id
select @.pages = @.pages + isnull(sum(used), 0)
from sysindexes
where indid = 255
and id = @.id
update #spt_space
set data = @.pages
where objid = @.id
/* index: sum(used) where indid in (0, 1, 255) - data */
update #spt_space
set indexp = (select sum(used)
from sysindexes
where indid in (0, 1, 255)
and id = @.id)
- data
where objid = @.id
/* unused: sum(reserved) - sum(used) where indid in (0, 1, 255) */
update #spt_space
set unused = reserved
- (select sum(used)
from sysindexes
where indid in (0, 1, 255)
and id = @.id)
where objid = @.id
update #spt_space
set rows = i.rows
from sysindexes i
where i.indid < 2
and i.id = @.id
and objid = @.id
fetch next from c_tables
into @.id
end
select --top 25
Table_Name = (select left(name,25) from sysobjects where id = objid),
rows = convert(char(11), rows),
reserved_MB = ltrim(str(reserved * d.low / 1048576.,15,0) + ' ' +
'MB'),
data_MB = ltrim(str(data * d.low / 1048576.,15,0) + ' ' + 'MB'),
index_size_MB = ltrim(str(indexp * d.low / 1048576.,15,0) + ' ' +
'MB'),
unused_MB = ltrim(str(unused * d.low / 1048576.,15,0) + ' ' + 'MB')
from #spt_space, master.dbo.spt_values d
where d.number = 1
and d.type = 'E'
order by reserved desc
drop table #spt_space
close c_tables
deallocate c_tables|||Antony wrote:
> I have a database under SQL2005 that in a 24 hour period has increased from
> 200MB to 2GB (this is the dbf file size not the log file size) and there are
> no obvious reasons for the increase. We have also tried Shrinking both the DB
> and file with little reduction in size. Is there a way to query the database
> and find out the sizes of tables etc to help with further investigation?
> Looking at the properties of each in Management studio really isn't feasible
> due to the number of objects. TIA
> Antony
There is a known bug with the auto-growth function in SQL 2005. Sounds
like that might be your problem.
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||This is a multi-part message in MIME format.
--=_NextPart_000_0468_01C71468.EBBF5E10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
This might be useful.
CREATE TABLE #Tables ( [name] nvarchar(20),
[rows] char(11),
[reserved] varchar(18),
[data] varchar(18),
[index_size] varchar(18),
[unused] varchar(18)
)
EXECUTE sp_MSForEachTable 'INSERT INTO #Tables EXECUTE sp_spaceused [?]'
SELECT [name],
[data]
FROM #Tables
DROP TABLE #Tables
-- Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous
You can't help someone get up a hill without getting a little closer to =the top yourself.
- H. Norman Schwarzkopf
"Antony" <info AT webpc DOT biz> wrote in message =news:u0L0oEKFHHA.3212@.TK2MSFTNGP02.phx.gbl...
>I have a database under SQL2005 that in a 24 hour period has increased =from
> 200MB to 2GB (this is the dbf file size not the log file size) and =there are
> no obvious reasons for the increase. We have also tried Shrinking both =the DB
> and file with little reduction in size. Is there a way to query the =database
> and find out the sizes of tables etc to help with further =investigation?
> Looking at the properties of each in Management studio really isn't =feasible
> due to the number of objects. TIA
> Antony
--=_NextPart_000_0468_01C71468.EBBF5E10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

This might be useful.
CREATE TABLE =#Tables ( [name] nvarchar(20), [rows] char(11), [reserved] varchar(18), [data] varchar(18), [index_size] varchar(18), =[unused] varchar(18) )
EXECUTE sp_MSForEachTable ='INSERT INTO #Tables EXECUTE sp_spaceused [?]'
SELECT [name], [data]FROM #Tables
DROP TABLE #Tables
-- Arnie Rowland, =Ph.D.Westwood Consulting, Inc
Most good judgment comes from =experience. Most experience comes from bad judgment. - Anonymous
You can't help someone get up a hill =without getting a little closer to the top yourself.- H. Norman Schwarzkopf
"Antony" =wrote in message news:u0L0oEKFHHA.3212@.TK2MSFTNGP02.phx.gbl...>I =have a database under SQL2005 that in a 24 hour period has increased from> 200MB =to 2GB (this is the dbf file size not the log file size) and there are> =no obvious reasons for the increase. We have also tried Shrinking both the DB> and file with little reduction in size. Is there a way to =query the database> and find out the sizes of tables etc to help with =further investigation?> Looking at the properties of each in Management =studio really isn't feasible> due to the number of objects. TIA> Antony

---

--=_NextPart_000_0468_01C71468.EBBF5E10--|||Thanks everyone for the advice. I found the table that was causing the issue.
Antony
On 11/30/2006 12:04:10 PM, "Antony" wrote:
>I have a database under SQL2005 that in a 24 hour period has increased from
>200MB to 2GB (this is the dbf file size not the log file size) and there are
>no obvious reasons for the increase. We have also tried Shrinking both the DB
>and file with little reduction in size. Is there a way to query the database
>and find out the sizes of tables etc to help with further investigation?
>Looking at the properties of each in Management studio really isn't feasible
>due to the number of objects. TIA
>Antony

How to Restrict all SQL Databases Size

Hello -

I have over 100 MSSQL Databases on my SQL SERVER. How do I restrict
all the MSSQL databases and its transaction logs to 100 MB.

Can someone help me with any script which will do that.

Thanks,

Rubal Jain
www.Rubal.netHi

This will depend on how/what these databases are and what you want to set
the sizes to.
A start could be the script created by:

EXEC master..sp_MSForEachdb 'USE ? SELECT ''ALTER DATABASE '' + db_name() +
'' MODIFY FILE ( name= '' + RTRIM(name) + '', MAXSIZE=200)'' FROM sysfiles
WHERE status & 0x40 <> 0x40 '

John

"Rubal Jain" <rubaljain@.yahoo.com> wrote in message
news:7a30b199.0407150445.56b2a480@.posting.google.c om...
> Hello -
> I have over 100 MSSQL Databases on my SQL SERVER. How do I restrict
> all the MSSQL databases and its transaction logs to 100 MB.
> Can someone help me with any script which will do that.
> Thanks,
> Rubal Jain
> www.Rubal.net